Designs, develops, and deploys Informatica PowerCenter ETL processes for data migration, transformation, and warehousing. Responsibilities include creating data integration strategies, writing and optimizing SQL and PL/SQL, monitoring and troubleshooting pipelines, ensuring data quality, documenting technical solutions, collaborating on requirements, and conducting code reviews. The role supports large-scale enterprise data environments and requires strong knowledge of data modeling, database architecture, and data warehousing.
Summary
We are seeking a highly skilled Informatica ETL Developer to join our IT Services team. In this pivotal role, you will architect, design, and implement robust data integration solutions that drive business intelligence and operational efficiency. The ideal candidate will leverage their extensive experience to optimize data workflows, ensure data quality, and support complex analytical requirements. This position is critical for maintaining the integrity of our data infrastructure and enabling seamless data flow across various enterprise systems.
Responsibilities
- Design, develop, and deploy scalable ETL processes using Informatica PowerCenter to facilitate data migration and transformation.
- Architect efficient data integration strategies that align with organizational data governance policies and performance standards.
- Write, test, and debug complex SQL and PL/SQL queries to extract, transform, and load data from diverse sources into data warehouses.
- Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications for data solutions.
- Monitor and troubleshoot ETL jobs, ensuring high availability and resolving performance bottlenecks in data pipelines.
- Document technical designs, data flow diagrams, and process documentation to support knowledge transfer and system maintenance.
- Conduct code reviews and implement best practices to enhance the reliability and maintainability of ETL frameworks.
Requirements
Requirements
- Minimum of 5 years of hands-on experience in ETL development within the IT Services sector.
- Proven expertise in Informatica ETL development, including mapping creation, workflow design, and transformation logic.
- Strong proficiency in SQL and PL/SQL for database manipulation, query optimization, and stored procedure development.
- Demonstrated ability to design and execute comprehensive ETL strategies for large-scale data environments.
- Solid understanding of data modeling concepts, database architecture, and data warehousing principles.
- Excellent problem-solving skills with the ability to analyze complex data issues and deliver effective solutions.
- Strong communication skills with the capacity to work collaboratively in a dynamic team environment.
Similar Jobs
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Provides systems safety engineering for aircraft turbine engines and auxiliary power systems. Conducts hazard and safety analyses, develops safety requirements and documentation, supports FAA and EASA compliance, performs reliability analysis, and reviews designs. Collaborates across engineering teams on risk mitigation, corrective actions, and aftermarket safety metrics. The role also supports process standardization, automation, AI application, technical coaching, innovation, and strategies to reduce certification cycle time and cost.
Top Skills:
Artificial IntelligenceDoorsDoors NgModel-Based Systems Engineering
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Leads embedded software and firmware development for processor simulators and emulators, including requirements, architecture, design, coding, qualification, and technical support. Develops QEMU and KVM-based tools, ports Linux or RTOS to SoCs, and works with ARM architectures and low-level hardware interfaces. Owns simulator strategy, roadmaps, issue resolution, design decisions, stakeholder collaboration, process improvement, and team mentoring while driving innovation and competitive product development.
Top Skills:
ArmAssemblyBitbucketCC++Do-178B/CDo-330DoorsEclipseEthernetGdbGpioKvmLauterbachLinuxMpsocPciQemuRtosSocSvnTrace32Visual Studio
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Leads reactive and proactive incident response engagements across India and APAC. Performs advanced host and network forensics on Windows, macOS, and Linux; advises customers during security incidents; develops remediation plans; presents findings to technical and executive audiences; and mentors junior team members. The role also involves threat intelligence, adversary attribution, thought leadership, and applying AI technologies to improve workflows and decision-making.
Top Skills:
Artificial IntelligenceComputer Forensics ToolsLinuxmacOSNetwork Analysis ToolsNetwork ProtocolsWindows
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
