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: harshaja@apptoza.com
Phone#:647-953-1625
...Company Description Landis Electric LLC has been doing Commercial and Residential electrical work in the Kansas City Metro for over 20 years. We pride ourselves on our excellent customer service, attention to detail, and all-inclusive training program. Want to become...
Job Title: Team Lead (Automotive & Contract Center) Location: Troy, MI Duration: Fulltime with Benefits Job Description: ~ Bring in Industry best-in class process knowledge and re-engineer the process towards making it self- serve and lean ~ Ideate, transform...
...customer service background essential One (1) year of Military, delivery driver with sales component or health care technician experience would be considered related experience and preferred. Senior level requires two (2) years of work-related experience and...
...are seeking energetic, highly motivated Flight Attendants who wish to join a committed group of... ...safety and service professionals at Avelo Airlines. We are a new, high value/low fare... ...at all times. Must possess a valid United States passport (or foreign passport with...
...experience credit added to base wage! RN Wage: $25.50 - 38.50 LPN Wage: $21.00 - 29.50 Job Summary The Registered Nurse (RN) is responsible for utilizing the nursing process (assessment, diagnosis, outcomes/planning, implementation and evaluation) to provide...