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
Security • Cybersecurity
Own global revenue recognition under ASC 606 and accounting processes including commissions, COGS, and leases. Review tax provisions, returns, transfer pricing, and subsidiary filings; support external audits and cross-functional reporting. Lead accounting projects, process improvements, and AI-driven workflow automation. Requires a CA, Big 4 high-tech experience, strong US GAAP and revenue recognition knowledge, ERP experience, advanced Excel skills, and excellent communication.
Top Skills:
Ai Automation ToolsAsc 340-40Asc 606ExcelMS OfficeNetSuiteUs Gaap
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Designs and deploys production AI assistants, copilots, agents, RAG systems, and intelligent automations. Integrates LLMs with Snowflake, AWS, enterprise applications, and workflow platforms to automate business processes. Builds backend services and serverless workflows, implements observability and responsible AI controls, and scales validated prototypes into reliable production solutions. Partners with technical and business teams to improve decision-making, efficiency, quality, and cost performance.
Top Skills:
AirflowAmazon Api GatewayAmazon BedrockAmazon EventbridgeAmazon S3Amazon SagemakerAnthropicAws LambdaAws Step FunctionsAzure OpenaiDbtGeminiGoMcpMicrosoft Power AutomateMlflowN8NOauthOpenaiPythonRbacSalesforceServicenowSnowflakeSnowflake Cortex SearchSnowflake Ml RegistrySnowparkSsoTypescriptUipathWeights & BiasesWorkato
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Perform software verification and validation for embedded aerospace platform components. Develop test plans, conduct requirement- and scenario-based testing, execute change impact analyses, resolve technical issues, support audits, and collaborate with stakeholders. The role requires embedded C/C++ and RTOS expertise, emulator and debugger experience, testing tools, technical leadership, and stakeholder management.
Top Skills:
BitbucketC++DeosDoors NgEmbedded CIcdJIRALauterbachLdraLinuxRtosVectorcast/Cover
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.
