Sr. ETL Informatica Developer

2 weeks ago

Hyderabad, Telangana, India Komhar InfoTech Pvt. Ltd Full time ₹ 5,00,000 - ₹ 15,00,000 per year

Job Summary:

We are looking for an experienced Informatica Developer with strong expertise in Snowflake, Teradata, and BTEQ to design, develop, and maintain efficient ETL solutions. The ideal candidate will be responsible for implementing data integration solutions, managing large datasets, and enabling data analytics by building robust data pipelines across various platforms.

Key Responsibilities:

  • Design, develop, and implement ETL solutions using Informatica PowerCenter, focusing on data extraction, transformation, and loading from multiple source systems into Snowflake and Teradata environments.
  • Develop and execute BTEQ scripts for Teradata database interactions, including data load, export, and monitoring jobs.
  • Work on data integration tasks to move data from various sources into Snowflake Data Warehouse, leveraging Snowflake-specific features such as stages, file formats, and streams.
  • Optimize ETL mappings, workflows, and BTEQ scripts for improved performance and reliability.
  • Implement data quality checks, data profiling, and data validation as part of the ETL process.
  • Collaborate with business analysts, data architects, and other technical teams to understand requirements and deliver scalable data solutions.
  • Troubleshoot and resolve ETL failures, data discrepancies, and performance bottlenecks.
  • Manage and monitor daily/weekly ETL jobs to ensure timely data delivery.
  • Maintain clear and detailed documentation of data mappings, workflows, BTEQ scripts, and technical designs.
  • Participate in unit testing, system integration testing, and production support activities.

Key Skills Required:

  • Strong hands-on experience in Informatica PowerCenter development (mappings, workflows, sessions, etc.).
  • In-depth knowledge of Snowflake Data Warehouse architecture and functionality (tables, stages, file formats, Snowpipe, etc.).
  • Experience with Teradata Database, including writing efficient SQL queries, BTEQ scripting, and handling large datasets.
  • Proficiency in BTEQ (Basic Teradata Query) for data load, export, and automation.
  • Strong SQL skills (Teradata SQL, Snowflake SQL) and performance tuning capabilities.
  • Experience in data modeling concepts (Star Schema, Snowflake Schema, Fact and Dimension Tables).
  • Knowledge of UNIX/Linux scripting for automating ETL and database jobs.
  • Strong problem-solving skills with attention to detail.
  • Good communication and collaboration abilities.

Educational Qualification:

  • Bachelor's degree in Computer Science, Information Technology, or related discipline.

Preferred (Optional):

  • Experience in Cloud Platforms (AWS, Azure)
  • Familiarity with version control tools (Git)
  • Exposure to workflow automation tools (Control-M, Autosys)

Job Type: Full-time

Pay: ₹500, ₹1,500,000.00 per year

Benefits:

  • Health insurance
  • Leave encashment
  • Provident Fund
  • Work from home

Work Location: In person

  • Informatica Cloud ETL Developer

    22 minutes ago

    Hyderabad, Telangana, India IDESLABS PRIVATE LIMITED Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Skill:Informatica Cloud ETL DeveloperNotice Period:ImmediateEmployment Type: ContractWork Mode: WFO/Hybrid5+ Years of strong experience in Informatica Cloud Exp in Informatica Cloud Designer & Informatica Cloud Portal Exp in Transformations, Mapping Configuration Task, Task Flows and Parameterized Templates Experience in Informatica Power Center and...

  • Informatica Developer

    3 weeks ago

    Hyderabad, Telangana, India Tata Consultancy Services Full time

    Greetings from TCS TCS is hiring for Informatica Power Centre Developer Job Location: Hyderabad Desired Experience Range: 4 to 10 Years As a Sr. Informatica Developer, the ideal candidate will become part of a team responsible for the complete lifecycle and the management of ETL processes and database systems. Collaborating with business, development and...

  • Informatica Developer

    3 weeks ago

    Hyderabad, Telangana, India Tata Consultancy Services Full time

    Greetings from TCSTCS is hiring for Informatica Power Centre DeveloperJob Location: HyderabadDesired Experience Range: 4 to 10 YearsAs a Sr. Informatica Developer, the ideal candidate will become part of a team responsible for the complete lifecycle and the management of ETL processes and database systems. Collaborating with business, development and testing...

  • Informatica Developer

    1 week ago

    Hyderabad, Telangana, India Coforge Full time

    We're Hiring: Informatica Developer.Location: Noida & Hyderabad, IndiaExperience Required: 4 to 8 YearsCompany: Coforge LtdJoin our dynamic ETL team and work on cutting-edge data integration projects using Informatica On-Prem and Informatica Cloud . This role offers the opportunity to lead complex ETL initiatives, collaborate with global teams, and...

  • Informatica Developer

    2 weeks ago

    Hyderabad, Telangana, India Coforge Full time

    We're Hiring: Informatica Developer. Location: Noida & Hyderabad, India Experience Required: 4 to 8 Years Company: Coforge LtdJoin our dynamic ETL team and work on cutting-edge data integration projects using Informatica On-Prem and Informatica Cloud. This role offers the opportunity to lead complex ETL initiatives, collaborate with global teams, and explore...

  • Informatica Developer

    2 weeks ago

    Hyderabad, Telangana, India Coforge Full time

    We're Hiring: Informatica Developer. Location: Noida & Hyderabad, India Experience Required: 4 to 8 Years Company: Coforge Ltd Join our dynamic ETL team and work on cutting-edge data integration projects using Informatica On-Prem and Informatica Cloud. This role offers the opportunity to lead complex ETL initiatives, collaborate with global teams, and...

  • Informatica Developer

    3 weeks ago

    Hyderabad, Telangana, India Coforge Full time

    We're Hiring: Informatica Developer. Location: Noida & Hyderabad, India Experience Required: 4 to 8 Years Company: Coforge LtdJoin our dynamic ETL team and work on cutting-edge data integration projects using Informatica On-Prem and Informatica Cloud. This role offers the opportunity to lead complex ETL initiatives, collaborate with global teams, and...

  • Informatica Developer

    3 weeks ago

    Hyderabad, Telangana, India Tata Consultancy Services Full time

    Dear Candidate, Greetings We have an opening for TCS, Hyderabad "Informatica Developers" Skill : Informatica Developers Experience : 5-7 Years Location: Hyderabad Please find below JD: Required Technical Skill Set: Informatica Developers Designing and developing software applications based on the Informatica platform Designing, developing and testing...

  • ETL Developer

    3 weeks ago

    Hyderabad, Telangana, India Zensar Technologies Full time

    ETL Developer InformaticaExperience : 5 to 7 YearsNotice Period : Immediate Joiners PreferredRole Overview :We are seeking a highly skilled ETL Developer with 57 years of hands-on experience in Informatica PowerCenter and Informatica Cloud. The ideal candidate will be responsible for designing, developing, and optimizing complex ETL workflows to support...

  • Senior ETL Developer

    2 weeks ago

    Hyderabad, Telangana, India Talpro Full time

    About the Role :We are seeking talented ETL Developers and Sr. Developers to design, build, and optimize data warehouse and ETL solutions. The role involves working closely with business stakeholders and engineering teams to ensure the timely delivery of high-performance, scalable, and reliable data pipelines supporting enterprise analytics and reporting.Key...