Job Order #2973

Email this Job to a Friend
Posted Date: 4/11/2018
Job Category:
Position Title: DataStage Developer
Salary Range:
Location: Toronto, Ontario, Canada
Desired Skills:

Our client is looking for an experienced DataStage Developer to join their team of accomplished tech professionals to develop robust Data Warehouse solutions. The senior developer must demonstrate data analysis and modeling experience, in addition to team leadership skills.

What They Do:
Our client produces high quality commercial systems for the banking, auto finance, capital markets, health insurance and pension plan industries (to name a few). They consistently work towards designing and building high-performing enterprise solutions with emphasis placed on great user experience, robust architecture, and a perfect fit. You’ll have the opportunity to contribute your technical expertise alongside a team of software specialists who are passionate about what they do.

What You’ll Do:
• Analyze and document business requirements based on client needs
• Preparation, maintenance and publishing of ETL documentation, including source-to-target mappings and business-driven transformation rules
• Propose technical designs and lead the implementation of large Data Warehousing solutions, supporting database(s), and complex ETL processes
• Development of ETL processes
• Analyze complex data sources and assist in the design of new data feeds
• Development of new features, mappings, and workflows
• Develop, test, deploy, maintain, support, tune, and fix ETL programs
• Automate the execution of various ETL processes
• Create technical documentation of all developed mappings
• Establish and implement unit test frameworks for ETL processes
• Perform code reviews

Your Preferred Profile:
• 5+ years of experience in analyzing business requirements to design, architect, develop and implement highly efficient, highly scalable ETL processes
• Hands on experience designing databases and implementing (SQL) scripts and stored procedures; Ms SQL Server, Oracle, experience is a mandatory requirement
• Experience with DataStage mandatory
• Ability to make recommendations for ETL design and performance enhancements for large data volume loads and processing
• Proficient with Windows and Unix operating systems
• Experience creating detailed unit test scripts; code and unit test components as per internal designs; participation in code reviews
• Nice to have: reporting tools experience such as Tableau, Sisense, Business Objects, SSRS

Share this job: