DataStage ETL Developer

On behalf of our client in the Banking Sector, PROCOM is looking for a DataStage ETL Developer.

DataStage ETL Developer – Job Description

  • The main function of a, DataStage ETL Developer is to design, develop, and implement applications to support business requirements
  • Converting Informatica in DataStage
  • Need someone who is more hands on with DataStage, not just working knowledge
  • As long as you have data stage experience that will be suffice
  • Don’t have to be an administrator, designer or director
  • Any experience with Data Stage will do

DataStage ETL Developer– Mandatory Skills

  • 5+ years of experience developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
  • Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML
  • Experienced in integration of various data sources (DB2-UDB, SQL Server, PL/SQL, Oracle, Teradata, XML and MS-Access) into data staging area
  • 5+ years working with Data Stage
  • 5+ years of experience in Database programming for Data Warehouses (Schemas), proficient in dimensional modeling
  • Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the Data Stage jobs using wrappers
  • Excellent knowledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions
  • Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement
  • Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development

DataStage ETL Developer – Nice to Have Skills

  • Prior FI or Banking experience
  • Experience in using software configuration management tools like Rational Clear case/Clear quest for version control
  • Experienced in Data Modeling as well as reverse engineering using tools Erwin, Oracle Designer and MS Visio, SQL server management studio, SSIS and SSRS and store procedure

DataStage ETL Developer – Assignment Start Date

ASAP – 6 months to start

DataStage ETL Developer – Assignment Location

Toronto, ON – Work Remotely

Tagged as: AGI