The ideal candidate will be responsible for designing, developing, and deploying scalable ETL processes using Informatica PowerCenter to support our data warehousing and analytics initiatives. You will collaborate with business and technical stakeholders to ensure high data quality, availability, and performance.
Key Responsibilities:
Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).
Extract, transform, and load data from various source systems (e.g., SQL Server, Oracle, flat files, cloud APIs) into data warehouses or operational data stores.
Optimize ETL performance, conduct tuning, and ensure error handling and logging.
Collaborate with data architects and analysts to understand data requirements and deliver high-quality data solutions.
Work with QA teams to support data validation and testing efforts.
Support data integration, migration, and transformation initiatives.
Document ETL processes, data flows, and job schedules.
Monitor daily ETL jobs and resolve production issues in a timely manner.
Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
3+ years of experience with Informatica PowerCenter or Informatica IICS.
Strong SQL skills and experience with relational databases (e.g., Oracle, SQL Server, PostgreSQL).
Solid understanding of data warehousing concepts and dimensional modeling.
Experience in performance tuning and troubleshooting ETL processes.
Hands-on experience with job scheduling tools (e.g., Autosys, Control-M, Tidal).
Familiarity with version control systems and DevOps practices.
Preferred Qualifications:
Experience with cloud data platforms (e.g., Snowflake, AWS Redshift, Azure Synapse).
Exposure to data governance and data quality tools.
Knowledge of scripting languages (e.g., Shell, Python).
Experience working in Agile/Scrum environments.
Familiarity with BI tools (e.g., Tableau, Power BI) is a plus.
This position comes with competitive compensation and benefits package:
If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.
Drive critical incident response and ITSM leadership for a leading US insurance provider through Capgemini’s global infrastructure services.
Capgemini partners with a leading U.S. insurer to find a motivated Associate Data Engineer skilled in data analytics, cloud technologies, and model deployment to drive key business insights.
Support Maya Angelou Schools as Manager of Data and Compliance by managing critical student and operational data to ensure compliance and improve educational outcomes for opportunity youth.
Support data quality and governance initiatives as a Junior Data Steward Analyst at MDVIP's corporate office in Boca Raton.
Bitsight is looking for a BI Engineer to optimize data infrastructure and analytics, supporting their mission to transform cyber risk management.
A Senior Data Engineer role at GM Motorsports to develop scalable data processing systems enhancing aerodynamic development for motorsports and production vehicles.
Technical leadership opportunity to architect and lead Fan Ecosystem’s central data platform as a Staff Data Engineer.
NexHealth is looking for a Staff Data Engineer to own and enhance foundational data systems that power analytics and customer insights in healthcare innovation.
A BI Architect role at Brillio focusing on leading modern data platform strategies and BI development using Snowflake, Azure, and PowerBI.
Lead the design and execution of Duet’s scalable data platform while mentoring a growing engineering team at a mission-driven healthcare startup.
Fifth Third Bank hires a Data Engineer II to build and optimize data solutions driving business intelligence and operational excellence in banking.
Experienced Informatica Admin needed to develop and support ETL solutions and enhance data warehouse functionalities using Informatica PowerCenter.
Join Visa as a Staff Data Engineer in Austin to design and build scalable data infrastructure and applications that empower innovative payment solutions worldwide.
Lead data governance and strategy initiatives at a top financial institution, managing data compliance and risk to enhance enterprise data quality and integrity.
A Senior GIS Data Specialist role focusing on designing and maintaining complex geospatial data systems for a leading Native American owned organization.
Capgemini partners with companies to transform and manage their business by unlocking the value of technology.
187 jobsSubscribe to Rise newsletter