K-936 ETL/DataStage Developer and Lead Toronto, ON - Hybrid - Long Term

K-936 ETL/DataStage Developer and Lead Toronto, ON - Hybrid - Long Term

Role - ETL/DataStage Developer Lead

Location Toronto, ON- Hybrid

Duration Long Term

Essential Skills:

1. Participate in all aspects of a systems development life cycle within the development team (Analysis, Design, Development, Test, QAT, Implementation, and Production Support).

2. Proficient in developing strategies for Extraction, Transformation, and Loading (ETL) mechanisms.

3. 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.

4. Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner, and Link Collector.





5. Experienced in the integration of various data sources (DB2-UDB, SQL Server, PL/SQL, Oracle, Teradata, XML, and MS-Access) into the data staging area.

6. Expert in working with Data Stage Manager, Designer, Administrator, and Director.

7. Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Index and Aggregate tables for the data warehouse design and development.

8. Excellent knowledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate the scheduling of multiple sessions.

9. Proven track record in troubleshooting Data Stage jobs and addressing production issues like performance tuning and enhancement.

10. Experienced in Database programming for Data Warehouses (Schemas), proficient in dimensional modeling

11. Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the Data Stage jobs using wrappers.

12.



Experience in using software configuration management tools like bitbucket for version control.

13. 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.

Thanks & Regards,

Harshaja

Apptoza Inc.

Email: [email protected]

Phone#:(phone hidden)

The original job offer can be found in Kit Job:
https://www.kitjob.ca/job/90010413/k-936-etl-datastage-developer-and-lead-toronto-hybrid-long-term-old-toronto/?utm_source=html