Sign upLog in

Lead Consultant | Data Management - Data Integration | DataStage

IMCS Group Inc

Minneapolis, MN

Apply
JOB DETAILS
SKILLS
Agile Programming Methodologies, Automation, Backlog Prioritization, Business Analysis, Call Centers, Cloud Computing, Consulting, Customer Support/Service, Data Management, Data Modeling, Data Processing, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Diversity Recruiting, Finance, Fortune 500 Customers, Git, Health Information Technology, Healthcare, IBM WebSphere DataStage, Microsoft Windows Azure, NCR Teradata, Oracle PL-SQL, Performance Tuning/Optimization, Production Support, Python Programming/Scripting Language, SQL (Structured Query Language), Scalable System Development, Snowflake Schema, Sprint Planning, Unix Operating Systems, Unix Shell Programming
LOCATION
Minneapolis, MN
POSTED
3 days ago
Company Description: IMCS Group is one of the fastest growing MWBE (Minority Woman Owned Enterprise) staffing firms in the U.S. We focus on bringing a Diversity Recruitment approach to Fortune 500 companies within North America and EMEA region contingent labor programs.  IMCS Group excels in providing top talent in IT, Healthcare, Engineering, Finance, Light Industrial, Contact Center, and Clerical.  We have offices in the US, Canada, Mexico, and India in which we can provide support to our clients.

Description: Job Title: Lead Consultant | Data Management - Data Integration | DataStage
Work Location: MinneapolisMN55427 (candidates within this area only)
Vendor Rate: ***
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, Python,Databricks 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 Teradata,Snowflake 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

Custom Fields:
Name: Intake Call Completed
Value: true

Name: Intake Call Requested
Value: true



EEOC Disclaimer: IMCS Group is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law. IMCS Group is committed to maintaining an inclusive workforce, where employees are hired, retained, compensated, and promoted based on their contributions to our Company.

About the Company

I

IMCS Group Inc