Job Summary
We are seeking a highly skilled DataStage Senior Developer with 5+ years of experience in designing, developing, and supporting enterprise data integration and ETL solutions using IBM InfoSphere DataStage.
The ideal candidate will possess strong expertise in data warehousing, ETL development, database technologies, and performance optimization, and will collaborate with business stakeholders, data architects, and development teams to deliver high-quality data solutions.
Key Responsibilities
• Design, develop, test, and deploy ETL processes using IBM InfoSphere DataStage.
• Analyze business requirements and translate them into effective ETL solutions.
• Develop and maintain DataStage jobs, sequences, shared containers, and reusable components.
• Perform data extraction, transformation, and loading (ETL) from multiple source systems into data warehouses and data marts.
• Optimize DataStage jobs for performance, scalability, and reliability.
• Monitor ETL workflows and troubleshoot production issues.
• Conduct data validation, reconciliation, and data quality checks.
• Collaborate with database teams to design and implement efficient data models.
• Create and maintain technical documentation, mapping documents, and deployment procedures.
• Participate in code reviews and ensure adherence to development standards and best practices.
• Support production releases, incident management, and root cause analysis.
• Work closely with Business Analysts, Architects, QA teams, and Support teams to deliver integrated data solutions.
Required Qualifications
• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 5+ years of hands-on experience with IBM InfoSphere DataStage development.
• Strong experience with IBM InfoSphere DataStage, including PX/Parallel Jobs, Server Jobs, and Sequences.
• Proficiency with DataStage Designer, Director, Administrator, and Parallel Extender (PX).
• Experience with job sequencing, workflow management, performance tuning, and optimization.
• Strong knowledge of ETL methodologies and data integration best practices.
• Experience working with large-volume data processing environments.
• Strong SQL and advanced SQL query development skills.
• Experience with Oracle, SQL Server, and PostgreSQL databases.
• Experience with UNIX/Linux Shell Scripting.
• Strong understanding of data warehousing concepts, dimensional modeling, fact tables, and dimension tables.
• Experience with data migration and data conversion initiatives.
• Experience using scheduling tools such as Control-M or AutoSys.
• Familiarity with version control tools such as Git, SVN, or similar platforms.
• Experience using JIRA or Agile project management tools.
• Experience providing production support and issue resolution.
• Understanding of Software Development Life Cycle (SDLC) and Agile methodologies.
• Strong analytical, problem-solving, communication, and stakeholder management skills.
• Ability to work independently and lead ETL development activities.
• Strong attention to detail, commitment to data quality, and ability to collaborate effectively within cross-functional teams.
Preferred Qualifications
• IBM DataStage Certification.
• Experience with Snowflake and cloud-based data platforms such as AWS or Azure.
• Experience with Python scripting.
• Knowledge of Data Governance and Data Quality frameworks.
• Experience with Big Data technologies such as Hadoop and Spark.
• Experience with Snowflake Data Warehouse implementations.
• Familiarity with Informatica, Talend, or other ETL tools.
• Experience with Databricks, Kafka, or real-time data integration technologies.
• Experience implementing CI/CD pipelines for ETL deployments.
Certifications
• IBM DataStage Certification.
