Technology Lead | Data Management - Data Integration | DataStage

IMCS Group Inc

Philadelphia, PA(remote)

JOB DETAILS
SKILLS
Analysis Skills, Call Centers, Centers for Disease Control and Prevention (CDC), Communication Skills, Customer Support/Service, Data Analysis, Data Management, Database Extract Transform and Load (ETL), Diversity Recruiting, Error Handling, Finance, Fortune 500 Customers, Health Information Technology, Healthcare, IBM WebSphere DataStage, Identify Issues, Linux Operating System, Oracle, Oracle 11i, Oracle Database, Oracle PL-SQL, Performance Tuning/Optimization, Problem Solving Skills, Production Support, Reconciliation, Root Cause Analysis, SQL (Structured Query Language), Technical Leadership, Unix Shell Programming
LOCATION
Philadelphia, PA
POSTED
10 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: *Priority requirement*

Job title Senior / Lead Data Warehouse & ETL Developer (IBM DataStage & Oracle)

Work location Philadelphia, PA

Is it Hybrid, onsite or remote position Hybrid (3 days/wk from client office in Philadelphia)

Tentative Start date Immediate ( Urgent requirement )

Contract duration 6 months (will be extended based on the performance)

Vendor rate - ***

Does this position require Visa independent candidates only? Yes

Mandatory skills
5 10+ years of experience in Data Warehousing and ETL development
IBM DataStage (8.x / 11.x preferred) strong hands-on experience
Oracle Database (11g/12c/19c) advanced SQL and PL/SQL
Enterprise Data Warehouse concepts (EDW, ODS, Data Marts)
ETL concepts: CDC, incremental loads, Slowly Changing Dimensions (SCD)
Performance tuning for ETL jobs and Oracle queries
Unix/Linux shell scripting (basic to intermediate)
Job scheduling tools (Tidal or equivalent)

Minimum years of experience needed in the required skills- 8-10 years

Minimum over all work experience required - 8

Domain - Healthcare

Any certification required good to have

Complete job description
Monitor, troubleshoot, and optimize DataStage job performance
Handle production support issues, reruns, and data reconciliations
Perform root cause analysis for ETL and data-related issues
Implement error handling, logging, and restartability in ETL jobs
Strong analytical and problem-solving skills
Ability to work independently and handle complex data issues
Good communication and stakeholder management skills
Production support and ownership mindset

Interview mode - In person/Virtual Virtual (Video)

How many rounds of interview - 2

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