Senior Software Engineer / Tech Lead / Senior Tech Lead

As a Data Engineering Senior Software Engineer / Tech Lead / Senior Tech Lead at a leading digital health platform in Navi Mumbai, Ghansoli, you will play a crucial role in designing, building, and optimizing ETL/ELT pipelines using tools like Pentaho, Talend, or similar. Your responsibilities will include working on traditional databases such as PostgreSQL, MSSQL, Oracle, as well as MPP/modern systems like Vertica, Redshift, BigQuery, and MongoDB. You will collaborate cross-functionally with BI, Finance, Sales, and Marketing teams to define data needs and participate in data modeling, data quality checks, and data integration. Additionally, you will be implementing solutions involving messaging systems like Kafka, REST APIs, and scheduler tools such as Airflow, Autosys, or Control-M while ensuring code versioning and documentation standards are followed using Git or Bitbucket. Key Responsibilities: - Design, build, and optimize ETL/ELT pipelines using tools like Pentaho, Talend, or similar - Work on traditional databases (PostgreSQL, MSSQL, Oracle) and MPP/modern systems (Vertica, Redshift, BigQuery, MongoDB) - Collaborate cross-functionally with BI, Finance, Sales, and Marketing teams to define data needs - Participate in data modeling (ER/DW/Star schema), data quality checks, and data integration - Implement solutions involving messaging systems (Kafka), REST APIs, and scheduler tools (Airflow, Autosys, Control-M) - Ensure code versioning and documentation standards are followed (Git/Bitbucket) Qualifications Required: - ETL Tools: Pentaho / Talend / SSIS / Informatica - Databases: PostgreSQL, Oracle, MSSQL, Vertica / Redshift / BigQuery - Orchestration: Airflow / Autosys / Control-M / JAMS - Modeling: Dimensional Modeling, ER Diagrams - Scripting: Python or Perl (Preferred) - Agile Environment, Git-based Version Control - Strong Communication and Documentation In this role, you will have the opportunity to work on hands-on development of ETL pipelines, data models, and data inventory as a Senior Software Engineer. As a Tech Lead, you will lead mid-sized data projects and small teams, deciding on ETL strategy and performance tuning. As a Senior Tech Lead, you will drive data architecture decisions, oversee large-scale data ingestion, and mentor junior leads while owning stakeholder delivery end-to-end. Experience with AdTech/Marketing data and the Hadoop ecosystem would be advantageous for the Senior Tech Lead role. Join this dynamic team if you are looking to contribute to a digital health platform and make a difference in the healthcare industry.,