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 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 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 Skills & Qualifications :
• 58 years of professional experience in software engineering, with a primary focus on ETL development.
• Strong, hands-on experience with Informatica as the primary ETL tool.
• Mandatory 2+ years of hands-on experience with Python scripting for data integration and API calls.
• Strong proficiency in writing complex SQL queries and performing query optimization.
• Expertise in Unix / Linux scripting.
• Practical experience with GitLab for source control and a basic understanding of CI / CD pipelines.
• Must be willing to perform L2 / L3 application support activities in addition to 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.

(ref : hirist.tech)