Datastage Developer

Datastage            Plano, Tx              2              $75k-$85K 
plus benefits                      • Must have extensive 4+ years of hands on technical experience in design/development of ETL Jobs using IBM DataStage 9
• Extensive development experience in Datastage 8.5 or above
• Experience in creating source to target mappings
• Experience in writing complex SQL in relational databases especially Teradata & Oracle
• Experience in ETL & query performance tuning
• Basic knowledge of UNIX Shell /Perl Scripting
• Efficient in all phases of SDLC Methodology (Agile / Scrum / Iterative Development, coherent with Data cleansing, data conversion, performance tuning and unit testing
• Proven experience with PL/SQL, SQL and Object Oriented concepts and design and relational database, Netezza, Oracle, etc.        • Builds Extract-Transform-Load (ETL) solutions for Data Integration and Data Warehousing (DW) using IBM InfoSphere DataStage (Designer, Director and Administrator) for wide variety of source and target formats (Mainframe, DB2, Oracle, Exadata, MS SQL Server, SalesForce Web API, XML, MQ, Hadoop)
• Creates objects in Relational Database and proficient in building moderate/complex SQL for data validation, manipulation and reporting
• Understands and applies DW Dimensional Modelling techniques such as Star, Snow-Flake and Data Vault
• Works on programming using UNIX shell scripting to enhance ETL solutions
• Knowledge and experience in Big Data Technologies is a plus
• Collaborates closely with stakeholders and groups (Billing, Product, Settlement, Customer, Accounting, Finance, File Transfer, and Support) to understand, refine and translate the business requirements into technical specifications
• Uses Scrum Agile methodology and Scaled Agile Framework (SAFe) to maximize the productivity and ensure quality
• Works in all phases of Software Development Life Cycle (SDLC) such as Requirements Gathering, Design, Development, All Testing (Unit, Integration, Regression, and User Acceptance), Production Deployment, and Support
• Works closely with IBM Tivoli Work Load Scheduler (TWS) team to automate/schedule various jobs taking in account complex systems interdependencies
• Assists Production Support in triaging various problems by doing root cause analysis and resolving the issue in timely manner to minimize impact to systems/environment
• Exercises judgment within defined procedures and practices to determine appropriate action
• Documents ETL processes & solutions by following the company standards for Support and Production Release
• Excellent communication and interpersonal skills. 

Want to apply later?

Type your email address below to receive a reminder

Apply to Job

ErrorRequired field
ErrorRequired field
ErrorRequired field
Error
Error
insert_drive_file
insert_drive_file