This role will be responsible to work on internal, external various data sources and system and integration of those systems with company application. He/she will work closely with business users to design and implement reporting and analytical solutions, including the design and development of table structures and the processes used to populate those structures with data from internal and external sources. He/she has to develop ETL processes using SQL, SSIS, with consideration to fault-tolerance, error logging, auditing and data quality.
Create data integration and technical solutions around Microsoft SQL Server, Informatica and various other ETL Tools.
Data modeling and requirements analysis.
Prepare storage logical and physical models based on requirements
Create end-to-end analytics and reporting solutions.
? Bachelor's degree in Computer Science, Engineering, or equivalent education
Experience with database/datawarehouse and ETL development.
SSIS, SSRS, SSAS
Experience with Informatica or other ETL tools outside of Microsoft a big PLUS
Advanced Structured Query Language (SQL)
Demonstrated ability to write transact-SQL / PL-SQL queries
Extensive experience with database/datawarehouse extraction and be comfortable with multiple ETL tools
Experience with Cloud computing concepts (private, public and hybrid) a plus
Experience working with reporting tools like Power Bi, Qlik Sense, Tableau a plus
Excellent written and verbal communication skills
Strong in Unix shell scripting.
Expertise in developing complex Stored Procedures, Functions, Packages.
Strong knowledge of performance tuning, query plan / explain plan analysis, indexing, table partitioning.
Expert in Data Architecture, Modeling, and any Modeling Tool.
Ability to create and manage sophisticated SSIS packages that import and validate data from various other SQL databases, flat files, and feeds (e.g. JSON, XML).
Validate ETL jobs against business use cases.
Develop and deploy all post-production enhancements.
Should have a familiarity with OLAP cubes
Ability to prioritize, perform multiple tasks and be a team player
If interested, email resume to
Analysis, Architecture, Data Architecture, Database, Data Modeling, DataWarehouse, Developer, Development, Informatica, Modeling, OLAP, Shell Scripting, SQL, SQL Server, Transact-SQL, Unix, XML
Robert Half Technology