IBM DataStage Developer

JD- Job Summary We are seeking an experienced IBM DataStage Developer to design, develop, enhance, and support enterprise-grade ETL solutions. The ideal candidate should have strong expertise in IBM DataStage, Oracle databases, Linux/Unix environments, and data warehousing concepts. The role involves developing scalable ETL processes, troubleshooting production issues, optimizing batch jobs, and collaborating with business and data teams to deliver high-quality data integration solutions. Key Responsibilities - Design, develop, test, and deploy ETL solutions using IBM DataStage. - Create and maintain Parallel Jobs, Sequence Jobs, Shared Containers, and reusable components. - Develop source-to-target mappings and implement complex data transformation logic. - Build and optimize ETL pipelines for high-volume data processing. - Integrate data from multiple sources including Oracle, SQL Server, flat files, APIs, and cloud storage. - Perform data validation, reconciliation, and quality checks. - Monitor daily batch processes and troubleshoot ETL job failures. - Analyze DataStage Director logs and identify root causes of production issues. - Develop and maintain shell scripts for orchestration, automation, and file processing. - Work with scheduling tools such as Control-M, Autosys, Airflow, or cron. - Support deployment activities across DEV, UAT, and PROD environments. - Collaborate with business analysts, data architects, DBAs, and reporting teams. - Participate in on-call support and incident management activities. - Prepare technical documentation, runbooks, and knowledge transfer materials. Required Skills ETL & Data Integration - IBM DataStage (PX/Parallel Extender) - Sequential Files, Dataset Stages - Transformer, Lookup, Join, Merge, Sort, Aggregator Stages - Sequence Jobs and Job Sequencers - Shared Containers and Parameter Sets - DataStage Director and Administrator Databases - Oracle (Preferred) - SQL Server - Advanced SQL and PL/SQL - Performance tuning and query optimization Operating Systems - Linux / Unix - Shell Scripting (Bash/Korn Shell) Data Warehousing - Data Warehouse Concepts - ETL Design Patterns - Data Modeling (Star/Snowflake Schema) - Data Migration and Data Quality Frameworks Scheduling & Monitoring - Control-M / Autosys / Airflow / Cron - Batch monitoring and job dependency management Version Control - Git / GitHub / Bitbucket Preferred Skills - Experience with Talend, Informatica, or other ETL tools. - Knowledge of AWS services such as S3, Glue, EMR, and Redshift. - Experience working with Media, AdTech, Analytics, or Reporting platforms. - Exposure to MicroStrategy, Power BI, or Tableau. - Understanding of CI/CD pipelines and DevOps practices. Qualifications - Bachelor's degree in Computer Science, Information Technology, or related field. - IBM DataStage certification is a plus. Desired Competencies - Strong analytical and troubleshooting skills. - Excellent communication and stakeholder management. - Ability to work independently in production support and enhancement projects. - Experience working in Agile/Scrum environments. - Strong documentation and knowledge-sharing practices.