Senior Data Warehouse ETL Developer
Job Description: • Design, develop, and deploy ETL mappings, workflows, and sessions using Informatica PowerCenter. • Extract data from heterogeneous source systems (e.g., Oracle, SQL Server, flat files, SAP) and load into target data warehouse environments. • Collaborate with business analysts and data architects to understand data requirements and translate them into efficient ETL solutions. • Optimize ETL processes for performance, scalability, and maintainability. • Conduct data validation, reconciliation, and troubleshooting to ensure data quality and integrity. • Maintain ETL documentation, including data flow diagrams, technical specifications, and process design documents. • Participate in code reviews, unit testing, and UAT support. • Monitor ETL jobs and workflows, identify bottlenecks, and implement improvements. • Provide production support and resolve data-related issues in a timely manner. Requirements: • Bachelor’s degree in Computer Science, Information Technology, or a related field. • 10 years of experience in ETL development using Informatica PowerCenter. • Strong understanding of data warehousing concepts, dimensional modeling, and star/snowflake schemas. • Experience with SQL, PL/SQL, and performance tuning of database queries. • Knowledge of data quality, data governance, and best practices in ETL development. • Strong analytical, problem-solving, and communication skills. • Experience with version control systems and ETL deployment processes. • Exposure to real-time ETL and data streaming technologies (preferred). • Knowledge of scheduling tools such as Informatica Workflow Manager and IBM Workload Automation (preferred). Benefits: • Health & Welfare Benefits: Comprehensive plans tailored to your needs, effective from day one. • Retirement Savings: Robust programs to help you secure your financial future. • Employee Discounts: Access to a wide range of discounts on merchandise, services, travel, and more. • Career Growth Opportunities: Paths for advancement within a global organization. • Paid Training: Learn while you earn with award-winning learning platforms. • Paid Time Off: Competitive PTO packages to help you recharge. • Great Work Environment: Join an award-winning culture that values diversity and inclusion.