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 current 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)