DataStage developer

Job Description

  • Permanent
  • Anywhere

looking for DataStage developer with over 8+ years experience..

Fulltime and Hybrid from Toronto, ON

Must experience with hashtag#PL/SQL and hashtag#SQL skills in relational database environment hashtag#RDBMS and Unix shell scripting

Job Description:

What will you do?
Strong experience in design and implement data pipelines
Strong PL/SQL and SQL skills in relational database environment
Strong hashtag#Unixshell hashtag#scripting skills
Create and review technical design documents, understand how the design will be used in the code development process, and facilitate meetings to design, troubleshoot, and execute projects
Participate in walkthrough reviews of technical specifications, programs, code, and unit test plans
Plan design/implementation activities, ensure technical solution quality, provide third-level support for various technologies, and drive technical platform evolution and improvements
Present technical topics at regular team meetings and manage low-level planning of work packages
Estimate activities/tasks required to perform design, coding, and unit testing
Excellent interpersonal and highly developed communication skills (verbal and written)
Ensure ETL pipelines are produced with the highest quality standards, metadata and validated for completeness and accuracy
Work closely with development teams to learn about needs, current processes and to promote best practices.
Knowledge of the Software Development Life Cycle (SDLC) – Agile, Waterfall, and Iterative methods
Working knowledge GitHub, CI/CD Pipeline

Must Have:
8+ years of experience working in complex and time-sensitive development environment
Extensive hands-on experience in hashtag#ETLdatastage
Extensive hands-on complex hashtag#SQL experience (hashtag#MSSQLServer, hashtag#Teradata)
Extensive experience in creating stored procedure and Unix shell scripting
Support at-scale testing to enable simulations, hashtag#UAT and reporting
Nice to Have:
Working knowledge of hashtag#Kafka
Working knowledge of JCL/Zeke