IT Lead Consultant | Data Management Data Integration | DataStage
Job Location:
Job Location:
Minneapolis, MN - USA
Monthly Salary:
Not Disclosed
Monthly Salary:
Posted on:
4 hours ago
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Job Title: Lead Consultant Data Management - Data Integration DataStage
Work Location: MinneapolisMN55427 (candidates within this area only)
Vendor Rate: 63.27
Contract duration: 6
Target Start Date: 01 Jul 2026
Does this position require Visa independent candidates only YES
**hybrid work set-up**
Job Details:
Must Have Skills: ETL Datastage Unix Airflow Teradata PythonDatabricks and Snowflake
Nice to Have Skills: SQL Azure Kubernetes Services DBT(Data Build Tool)
Detailed Job Description
As a Developer understand the current business and gain deep knowledge about it and collaborate with Business Analysts to gather and refine user and system requirements to develop healthcare pipelines.
collaborate with Business analysts abd data modellers to define and implement data models in On-Prim and Cloud Azure
Design and Develope scalable ETL pipelines using Datastage Python Snowflake and databricks for enterprise datawarehouse and Operational data stores.
Create transformation logic to process data from Flat files or tables to TeradataSnowflake and ADB.
Migrate the developed code to higher environments using GIT and ML Deployer and provide production support till it is handed over to operations team.
Develop complex SQL queries and validate ETL outputs against Source to Target mappings.
Work on automation using unix shell script Python and Pearl for data validation Cleansing and Process orchestration.
Conducted performace tuning and optimization of SQL and PL/SQL queris across Teradata Snowflake and Databricks.
Process the files through the newly developed code and provide the validated results to business.
Work on production support and enhancement workstreams.
Participating in Agile developement with Rally for sprint planning and backlog tracking.
Minimum years of experience
>10 years
Certifications Needed :No
Top 3 responsibilities you would expect the Subcon to shoulder and execute
Development
Testing and Support
Interview Process (Is face to face required)
No
Any additional information you would like to share about the project specs/ nature of work Project Code :Child code for DNA
Work Location: MinneapolisMN55427 (candidates within this area only)
Vendor Rate: 63.27
Contract duration: 6
Target Start Date: 01 Jul 2026
Does this position require Visa independent candidates only YES
**hybrid work set-up**
Job Details:
Must Have Skills: ETL Datastage Unix Airflow Teradata PythonDatabricks and Snowflake
Nice to Have Skills: SQL Azure Kubernetes Services DBT(Data Build Tool)
Detailed Job Description
As a Developer understand the current business and gain deep knowledge about it and collaborate with Business Analysts to gather and refine user and system requirements to develop healthcare pipelines.
collaborate with Business analysts abd data modellers to define and implement data models in On-Prim and Cloud Azure
Design and Develope scalable ETL pipelines using Datastage Python Snowflake and databricks for enterprise datawarehouse and Operational data stores.
Create transformation logic to process data from Flat files or tables to TeradataSnowflake and ADB.
Migrate the developed code to higher environments using GIT and ML Deployer and provide production support till it is handed over to operations team.
Develop complex SQL queries and validate ETL outputs against Source to Target mappings.
Work on automation using unix shell script Python and Pearl for data validation Cleansing and Process orchestration.
Conducted performace tuning and optimization of SQL and PL/SQL queris across Teradata Snowflake and Databricks.
Process the files through the newly developed code and provide the validated results to business.
Work on production support and enhancement workstreams.
Participating in Agile developement with Rally for sprint planning and backlog tracking.
Minimum years of experience
>10 years
Certifications Needed :No
Top 3 responsibilities you would expect the Subcon to shoulder and execute
Development
Testing and Support
Interview Process (Is face to face required)
No
Any additional information you would like to share about the project specs/ nature of work Project Code :Child code for DNA
