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
Artificial Intelligence • Productivity • Software • Automation
Leads Zapier’s India entity as statutory Board Director and General Manager. Owns local operations, governance, legal, tax, audit, transfer pricing, regulatory compliance, risk management, vendor relationships, and people decisions. Serves as the bridge between India-based teams and global leadership, translating strategy into execution and establishing operating rhythms for a fully remote workforce. Partners with Deloitte, HR, finance, auditors, regulators, and global executives while overseeing hiring, performance, compensation, employee relations, and compliance with Indian labor requirements.
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Develop advanced avionics features for Honeywell’s ANTHEM cockpit platform. Responsibilities include analyzing customer and operational requirements, defining system architecture, managing requirements, integrating and testing systems, troubleshooting interfaces, conducting design reviews, and supporting SRR, PDR, and CDR milestones. The role requires collaboration across global teams, avionics certification knowledge, Agile development experience, and strong systems engineering expertise.
Top Skills:
AgileArp4754AAtlassian JiraAvionics ArchitectureAvionics SoftwareAvionics SystemsDisplay SystemsEpic/ApexIbm Rational Doors NgSystems EngineeringSystems Safety Analysis
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Leads the architecture, development, and productionization of AI/ML and GenAI solutions for healthcare operations. Responsibilities include building clinical and claims data pipelines, developing LLM and RAG applications, implementing MLOps and LLMOps, ensuring HIPAA-compliant governance, translating business needs into technical roadmaps, communicating with stakeholders, and mentoring engineers.
Top Skills:
AirflowAWSAzureAzure MlBigQueryCi/CdDaskDatabricksDockerFaissGCPGitGoHugging FaceJavaKafkaKubernetesLangchainLlamaindexMlflowNeo4JNumpyPandasPgvectorPineconePrefectPytestPythonPyTorchSagemakerScalaSnowflakeSparkSQLTensorFlowTerraformTransformersVertex Ai
What you need to know about the Delhi Tech Scene
Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.
