Job Description :

Hope you are doing good. Please let me know if you are available for the below position. Please send me your updated resume along with the contact details and availability.

USC and those authorized to work in US are encouraged to apply, we are unable to sponsor H1 candidate this time.

Job Title: ETL Developer
Location: - Chicago, IL
Duration: 6 Month possible extension.
7+ year’s relevant experience required.
Design, develop, and maintain relational databases for data storage and data mining.
Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation.
Design data warehouse schematics, layouts, and capacity planning. Create and implement effective metrics and monitoring processes.
Develop processes and procedures for entering information into data warehousing systems and for ensuring reliability of information entered.
Seek continuous improvement in performance of data warehouse and ensure security of data.
Conducts complex work important to the organization Works under minimal supervision with wide latitude for independent judgment.

Developer will support the Revenue Management IT ''Gemini'' project by performing the following tasks:

Data extraction from different sources such as SQL Server, Teradata, flat files, Excel, and XML files into staging, transformation necessary to recast source data for analysis, and loading of transformed data into the presentation repository. It includes the selection criteria to extract data from source systems, perform any necessary data transformations or derivations needed data quality audits, and cleansing.

Data Modeling: Design and implementation of data models for both integration and presentation repositories. Creation of OLAP Cubes, cube partitions, and star schema designs including hierarchical and slowly changing dimensions.

Production Automation: Design and schedule the ETL/ELT process for periodic automated updates, including FTP/SFTP file transfers. Automated update processes must have built-in fail-over strategies and must ensure data consistency and correctness.

T-SQL Programming: Writing complex stored procedures, efficient SQL Queries with joins, and tuning for optimal performance.

Skillset Details:-

MS SQL Server Integration Services (SSIS), DW Loader MS SQL SERVER T-SQL, Stored Procedures SQL Server Management Studio, SQL Query Analyzer

Client : Generic solution