Job Summary
ETL Developer - Sr Developer with eight to ten years of experience will design and optimize robust data integration solutions using Informatica Powercenter and PowerExchange SQL PL SQL ETL and data warehousing concepts in a hybrid work model. The role focuses on building scalable data pipelines ensuring data quality and supporting business analytics while collaborating across teams in a day shift environment.
Responsibilities
- Design and implement complex ETL workflows using Informatica Powercenter and PowerExchange to deliver reliable data integration solutions that support critical business reporting and analytics needs.
- Optimize PL SQL procedures and SQL queries to improve performance stability and scalability of data processing jobs while ensuring efficient resource usage across enterprise data platforms.
- Develop and maintain robust data pipelines that move and transform data across heterogeneous systems by applying strong data warehousing concepts and best practices in dimensional modeling and normalization.
- Collaborate with business analysts and data consumers to translate functional requirements into technical ETL designs that accurately capture data transformation rules and business logic for downstream consumption.
- Monitor daily batch runs and real time data integration processes to proactively identify issues analyze root causes and implement corrective actions that maintain high data availability and integrity.
- Create and maintain detailed technical documentation for ETL jobs database objects and data flows to ensure clear traceability easier onboarding of new team members and smoother handovers during project transitions.
- Implement data quality checks validation rules and reconciliation routines within ETL workflows to reduce defects enhance trust in analytical outputs and support regulatory and audit requirements.
- Coordinate deployments of data integration components across development test and production environments by following standardized release processes and ensuring minimal disruption to business operations.
- Use Unix shell scripting to automate routine operational tasks such as job scheduling file handling and log management thereby improving productivity and reducing manual intervention.
- Collaborate in a hybrid work model with distributed team members using clear communication and structured status updates to ensure alignment on priorities timelines and delivery expectations.
- Contribute to continuous improvement initiatives by evaluating new Informatica features data integration patterns and performance tuning techniques that enhance platform efficiency and business value.
- Support incident resolution and defect fixes in a day shift schedule by analyzing issues in ETL workflows SQL scripts and Unix jobs and implementing robust long term solutions that prevent recurrence.
- Mentor junior developers through code reviews knowledge sharing sessions and guidance on ETL design standards to uplift overall team capability and project execution quality.
Qualifications
- Demonstrate advanced proficiency in Informatica Powercenter and PowerExchange including mapping design session configuration and workflow orchestration for large scale data integration projects.
- Show strong command of PL SQL and SQL with the ability to write complex queries stored procedures and performance tuned scripts for transactional and analytical data processing.
- Apply deep understanding of data warehousing concepts including star schemas slowly changing dimensions and fact table design to build scalable and maintainable analytical data structures.
- Exhibit practical expertise in ETL methodologies such as extraction strategies transformation patterns and load optimization techniques tailored for high volume enterprise data environments.
- Utilize solid experience in data integration to connect diverse source systems and targets ensuring consistent data definitions standardized interfaces and dependable data movement.
- Use Unix shell scripting skills to create automation utilities for job control error handling and environment housekeeping contributing to smoother operations and reduced manual workload.
Certifications Required
Informatica Certified Professional Oracle PL SQL Developer Certified Associate
Sobre a Cognizant
Cognizant (NASDAQ: CTSH) é uma construtora de IA e fornecedora de serviços de tecnologia, criando a ponte entre o investimento em IA e o valor para as empresas por meio do desenvolvimento de soluções de IA completas para nossos clientes. Nossa profunda experiência em setores, processos e engenharia nos permite incorporar o contexto único de cada organização em sistemas tecnológicos que potencializam a capacidade humana, geram resultados tangíveis e mantêm empresas globais à frente em um mundo em rápida transformação. Saiba mais em cognizant.ai ou @cognizant.
A Cognizant é uma empregadora que investe em equidade. Sua candidatura não será pautada em raça, cor, gênero, sexualidade, credo, origem, deficiência, gravidez ou qualquer outra característica protegida pelas leis brasileiras.
Informações adicionais de emprego
Os candidatos podem ser obrigados a comparecer a entrevistas presenciais ou por videoconferência. Além disso, os candidatos podem ser obrigados a apresentar seu documento de identificação emitido pelo estado ou governo atual durante cada entrevista.
Embora nosso sistema permita a candidatura em todos os idiomas, o(s) idioma(s) e o(s) nível(is) de proficiência exigidos para o trabalho variam. No entanto, é necessário um nível básico de inglês para fins de comunicação em toda a empresa.
A Cognizant é uma empregadora que investe em equidade. Sua candidatura não será pautada em raça, cor, gênero, sexualidade, credo, origem, deficiência, gravidez ou qualquer outra característica protegida pelas leis brasileiras.
Se você tem uma deficiência que requer adaptações razoáveis para procurar uma vaga de emprego ou enviar uma candidatura, envie um e-mail para [email protected] com sua solicitação e informações de contato.
