Design, Develop, and Maintain ETL Processes: Create and manage ETL workflows using Informatica PowerCenter, PowerExchange, and other related technologies.
Data Integration: Collaborate with business analysts and data architects to translate business requirements into technical specifications and implement efficient data integration solutions.
Performance Optimization: Optimize ETL processes for performance and efficiency, ensuring minimal downtime and maximum throughput.
Data Quality and Integrity: Ensure data quality and integrity throughout the ETL process, implementing data validation and cleansing routines.
Testing and Troubleshooting: Conduct unit and integration testing of ETL processes, troubleshoot issues, and provide post-production support.
Documentation: Maintain comprehensive documentation of ETL processes, data mappings, and workflows.
Collaboration: Work closely with cross-functional teams to define data requirements and contribute to database design decisions.
Qualifications:
Educational Background: Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
Experience: 5-8 years of experience in ETL development, with a strong focus on Informatica tools.
Technical Skills:
Proficiency in Informatica PowerCenter and other Informatica products.
Strong SQL skills and experience with databases like Azure DB and SQL Server
Knowledge of data warehousing concepts and BI architecture.
Knowledge of Insurance, Guidewire PolicyCenter and Policy Migration Tool will be added advantage.
Experience with UNIX/Linux scripting and scheduling tools.
Familiarity with data modeling techniques and schema designs (e.g., star, snowflake schemas).
Soft Skills:
Excellent problem-solving and analytical skills.
Strong communication and teamwork abilities.
Ability to work independently and manage multiple tasks simultaneously.
Numbers & Facts
Location
Bloomington, IL
Skills
Analysis Skillsunmatched
Business Analysisunmatched
Business Intelligenceunmatched
Communication Skillsunmatched
Computer Scienceunmatched
Cross-Functionalunmatched
Data Modelingunmatched
Data Processingunmatched
Data Qualityunmatched
Data Warehousingunmatched
Database Designunmatched
Database Extract Transform and Load (ETL)unmatched
Database Technologyunmatched
Documentationunmatched
Guidewireunmatched
Informaticaunmatched
Information Technology & Information Systemsunmatched
Insuranceunmatched
Integration Testingunmatched
Linux Operating Systemunmatched
Microsoft SQL Serverunmatched
Microsoft Windows Azureunmatched
Multitaskingunmatched
Performance Tuning/Optimizationunmatched
Problem Solving Skillsunmatched
Process Improvementunmatched
Production Supportunmatched
Requirements Managementunmatched
SQL (Structured Query Language)unmatched
Snowflake Schemaunmatched
Star Schemaunmatched
Team Playerunmatched
Testingunmatched
Unit Testunmatched
Unix Shell Programmingunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.