DataStage ETL Developer W

Profile

Role: ETL DataStage Developer
Location: Remote
Duration: Long Term
Terms: W2
JD:
Responsibilities:
Collaborate with the development team to understand the existing DataStage ETL jobs and their functionalities.
Test and validate the existing DataStage ETL jobs to ensure their accuracy and reliability.
Analyze the requirements for migrating from DB2 to MySQL and propose appropriate modifications to the DataStage jobs.
Modify and enhance the existing DataStage ETL jobs to align with the MySQL database structure and SQL syntax.
Perform data mapping and transformation tasks to ensure seamless integration between the source and target databases.
Optimize and fine-tune the DataStage jobs to achieve optimal performance and efficiency in the MySQL environment.
Conduct thorough testing and debugging of the modified DataStage ETL jobs to validate their functionality and data integrity.
Collaborate with database administrators, developers, and stakeholders to resolve any issues or challenges during the migration process.
Document the modifications made to the DataStage jobs, including data mappings, transformations, and SQL queries, for future reference.
REQUIREMENTS:
Proven experience as a DataStage ETL developer or consultant, with a focus on job testing and modification.
Strong knowledge of IBM InfoSphere DataStage and its various components.
Proficiency in SQL and a deep understanding of database concepts.
Familiarity with MySQL and its specific flavor of SQL (MySQL syntax, functions, and optimizations).
Experience in migrating ETL processes from DB2 to MySQL highly preferred.
Solid understanding of data integration, data warehousing, and ETL best practices.
Strong analytical and problem-solving skills, with the ability to identify issues and provide effective solutions.
Excellent communication and collaboration skills.
Ability to work independently, prioritize tasks, and meet project deadlines.
**MEMBERS ONLY**SIGN UP NOW***.

Company info

Sign Up Now - WashingtondcCrossing.com