ETL Developer

• *Role Description**

• *Designation**\-Senior Specialist – Development

• *Team Name** \-DA Team

• *Employment Type\-**Permanent

• *Accountability**

• *Core Responsibility**

· Understand the project scope, identify activities/ tasks, task level estimates, schedule, dependencies, risks and provide inputs to Program Lead for review.

· Develop a robust ETL solutions which can best meet the business requirements for investments applications.

· Analyze the data sources, be it a RDBMS or XLSX, CSV file or any other data source.

· Understanding of scheduling tools.

· Prepare/Modify design documents (High level design and Detailed design documents) based on business requirements.

· Suggest changes in design on technical grounds.

· Work on the functional and technical upgrades of the application.

· Coordinate delivery of the assigned tasks with the onshore Partners or/and Business Analyst.

· Ensure timely notification and escalation of possible issues/problems, options and recommendations for prompt resolution.

· Follow development standards to ensure that code is clear, efficient, logical and easily maintainable.

· Create and maintain application documentation like Network diagrams, Technical project handbook, technical data mapping doc, unit test documents, implementation plan.

· Ensure SLF Information Security Policies and General Computing Control is compiled to in all situations.

· Take complete ownership of work assignments and ensure the successful completion of assigned tasks.

· Ensure all written and verbal communication is clear, understandable and audience appropriate.

· **Knowledge of Informatica/ IDMC is good\-to\-have.**

· **Flexibility to work on different technologies will be preferred.**

• *Eligibility**

• *Minimum Qualification**

• A degree in Computer Science, related technology degree, or equivalent experience.

• *Industry Experience**

• Minimum 4 to 7 years of overall IT experience.
• Strong knowledge of AWS services like (S3, Glue, Lambda, Step Functions).
• Strong experience in PySpark/ Python.
• Relational databases (Microsoft SQL Server), PLSQL.
• Scheduling tools like zeke, Control M etc.
• AWS/ Python knowledge is good to have.

• *Competencies (Technical)**

• *Mandate Skills**

• **Design and Development**
• Excellent problem solving skills with the ability to analyze business problems systematically and deliver effective right\-sized solutions in a timely manner.
• Exposure to create scheduling jobs.
• Proven analysis and design/development skills on ETL platforms.
• Design, Develop, Test and Implement the changes following the Software Development. Life Cycle methodologies and quality concepts.
• Hands on experience on CDI (Cloud Data Integration) development, implementation \& support.
• **Technical Skills**
• Good knowledge of data warehousing concepts.
• Good analytical and problem solving skills.
• Strong knowledge on ETL (extract, transform, and load) tools \- Informatica PowerCenter \& IICS (Informatica Intelligent Cloud Services).
• Working knowledge on job scheduling tools like zeke, Control\-M, Autosys etc.
• Experience in DevOps tool (Jenkins \& Bitbucket).

• *Preferred skills**

• **Technical Skills**
• Strong knowledge of relational database (Microsoft SQL Server) and stored procedures.
• Hands on experience on CAI (Cloud Application Integration) development, implementation \& support.
• Experience with various DevOps tools \- source code management tools such as Jenkins, Bit bucket, CI CD tools – Ansible, CDD etc.
• Knowledge of APIs.
• Experience of Agile methodology.
• Hands on experience on ZEKE \& Control M scheduling.
• Basic knowledge of AWS ecosystem \& services (EC2, S3 etc).
• **Functional Knowledge**
• Knowledge on Insurance Industry domain.

Pay: ₹1,000,000\.00 \- ₹1,500,000\.00 per year

Benefits

• Paid sick time
• Paid time off

Application Question(s)

• Notice Period
• Expected Salary
• Must have hands on experience in AWS \& Python
• Must be available for face to face interview

Experience

• ETL Development: 4 years (Required)

Work Location: In person