[Hiring] ETL Developer - IBM DataStage @Gainwell Technologies LLC

Role Description

As ETL Developer - IBM DataStage at Gainwell, you will be responsible for managing and enhancing an advanced SQL-based healthcare data environment. This role involves requirement gathering, design documentation, data analysis, and developing robust ETL processes to support the Medicaid T MSIS program. The ideal candidate is highly skilled in SQL, PL/SQL or IBM DataStage, ETL development, shell scripting, and database performance optimization. This role is strictly involved in the development of the product and does not involve access to Protected Health Information (PHI) & Personally Identifiable Information (PII) or any secured/confidential client data. The work is limited to application development and does not include handling or processing of sensitive health information.

Qualifications

• 3+ years of hands-on experience in SQL development, PL/SQL, or IBM DataStage.
• Strong understanding of advanced SQL, relational database concepts, and query optimization.
• Proficiency in writing Linux/Unix shell scripts.
• Experience with ETL design, development, and troubleshooting.
• Solid analytical skills with an ability to work with large, complex datasets.
• Excellent verbal and written communication skills.
• Strong problem solving abilities and capability to multitask effectively.
• Experience working with large-scale healthcare data integration projects.
• Knowledge of data warehousing concepts and tools.
• Exposure to agile development methodologies.

Requirements

• Develop, enhance, and maintain ETL processes using PL/SQL or IBM DataStage.
• Build complex workflows, mappings, and automation scripts to meet T MSIS reporting requirements.
• Write efficient shell scripts to support ETL orchestration and automation.
• Perform data transformation, integration, and validation across large healthcare datasets.
• Collaborate with business and technical stakeholders to gather and document requirements.
• Prepare detailed technical design documents based on functional requirements.
• Perform in-depth data analysis to troubleshoot data quality, inconsistencies, and performance issues.
• Manage and optimize large SQL databases containing healthcare information.
• Apply advanced database administration techniques and query performance tuning.
• Ensure scalability, efficiency, and reliability of database and ETL components.

Benefits

• Remote Opportunity
• Must be comfortable working shift time (2pm - 11pm IST)