Natobotics - Senior Software Engineer - ETL/Informatica Development

Senior Software Engineer - ETL Informatica

Experience : 58 Years

Location : Mumbai (Local candidates only) / Pune (Ready to relocate)

Notice Period : Up to 60 days

Interview Mode : Virtual (1st Round), On-site F2F (2nd/3rd Round)

Job Summary :

We are hiring a skilled and experienced Senior Software Engineer with 58 years of hands-on experience in ETL Informatica development and support for our investment banking client. The ideal candidate will be an expert in the entire ETL lifecycle, from development to production support, with a strong command of complex SQL and scripting. This role is mandatory for candidates with a minimum of 2 years of hands-on Python scripting experience and a solid understanding of modern DevOps practices to ensure seamless deployment and integration.

Key Responsibilities :

- ETL Development & Support: Lead end-to-end development, implementation, and maintenance of ETL processes using Informatica (version 10 or later preferred). The role requires a candidate to be flexible and equally proficient in both new development and L2/L3 application support.

- Database & SQL Expertise: Write and optimize complex SQL queries for large-scale data transformation and analysis. You must have a strong understanding of database concepts, execution plans, and query optimization techniques to ensure high performance.

- Scripting & Automation: Utilize Unix/Linux scripting for automating critical tasks such as file movement, directory management, and NFS mounting.

- Python Integration: Develop and maintain Python scripts to facilitate API calls and data integration from multiple source systems, with a minimum of 2+ years of practical experience in this area.

- Release & Deployment Management: Contribute to the modern SDLC by using GitLab for source control, including branch management and commits. You should have prior working knowledge of CI/CD pipelines using tools like GitLab CI/CD and Jenkins to support automated build and deployment processes.

- Documentation & Communication: Collaborate effectively in an Agile environment, from requirement gathering to migration. The candidate should be self-motivated, proactive, and able to manage multiple tasks while creating necessary functional and technical documentation.

Required Skills & Qualifications :

- 58 years of professional experience in software engineering, with a primary focus on ETL development.

Preferred Skills :

- Experience with reporting and visualization tools like Tableau, Denodo, or Alteryx.

- Knowledge of cloud data technologies, particularly Snowflake.

- Familiarity with AI/ML concepts, such as LLM and ML models.

- Experience with documentation and project management tools like Confluence, JIRA, or SharePoint.