Etl Developer-datastage

Function EDC Canada

Service Line EDC Canada Solutions Delivery

Job Level Contractor

Skill set required ETL - Data Integration tools – IBM DataStage

Graduation B.E. / Btech. Any Graduate

Professional qualification Any

Work Experience 4-5 years

The key job responsibilities include the following:

The Solutions Delivery group with Deloitte Canada’s ITS (Information Technology Services department) requires an experienced developer to contribute as technical team member for major software development projects. This role requires:

• ETL application development experience using IBM DataStage (InfoSphere suite)
• ETL design experience
• Solid grounding in relational database (Microsoft SQL Server)
• Web services and message queue design and development experience
• Experience working on Cloud (Azure) and services like Azure Data factory will be an added advantage
• Experience working in a Hadoop environment will be an added advantage
• Good understanding of software development life cycle management
• Ability to work / interact effectively with remote team members
• Adhere to Deloitte Canada coding standards, procedures and techniques and contribute to the technical code documentation
• Remain well informed of new technologies / programming languages

This role will be responsible for:

• Design and development of ETL systems, data integration solutions, ensuring proper coding standards, procedures and techniques are followed
• Act as the subject matter expert on development techniques
• Design and develop migration of data/ETL to Cloud(Azure) based services
• Creates technical code documentation and participates as a contributor in solution design and estimation
• Perform unit testing and analyze / report the results to pertinent teams
• Troubleshoot errors and problems reported by QA, product owners, and end users while documenting how to resolve issues
• Identify / troubleshoot application code-related issues (provide 3rd level production support / issue resolution)
• Contributes to direction, product and project planning and SDLC practices for ETL/big data-oriented projects. Possesses in-depth knowledge and enforces standards, procedures, and methodologies. Supports the maturing of systems engineering, quality assurance and analysis policies, procedures, standards for data integration projects in line with organizational standards
• Participates in the architecture Community of Practice

The key skills required

General Skills and Qualifications

• Excellent organizational and communication skills
• Must have strong interpersonal skills, and the ability to effectively work with others in teams
• Strong problem solving skills in identifying issues and resolution
• Adeptness at learning new technology and tools
• The ability to effectively manage multiple assignments and responsibilities in a fast-paced environment
• Strong commitment to professional client service excellence
• Should be a strong individual contributor

Technical Skills and Qualifications

• Expert knowledge and familiarity with ETL tools
• Expert in developing solutions and deliver the high quality projects using IBM DatStage
• Expert on data integration tools, such as SQL Server Integration Services (SSIS), Data Stage
• Expertise on Web Service design and development (including SOAP, XML, .Net) - Preferable.
• Expertise on message queue design and development - Preferable
• Knowledge on Cloud based ETL services – Preferable
• Knowledge on basic Python programming - Preferable
• Knowledge on Hadoop environments and architecture
• Knowledge on Microsoft Systems Center Orchestrator
• Knowledge on PGP
• Knowledge on GlobalSCAPE Cute FTP or Robo-FTP (a plus)
• Knowledge on Alteryx (a plus)
• Experience with IBM Cognos Data Manager (a plus)
• Knowledge on Microsoft VB Script and PowerShell (a plus)

Other details

Work timing 11 AM – 8.00 PM