What are the responsibilities and job description for the ETL/Informatica Developer position at ConsultUSA?
Description:
Our client has an immediate need for an ETL/Informatica Developer, who will be responsible for designing, developing, and maintaining Extract, Transform, Load (ETL) processes using Informatica PowerCenter and other ETL tools to integrate data from multiple sources into a central data warehouse or other target systems
Requirements:
- Bachelor's degree is a plus
- Informatica or Salesforce Certifications preferred
- Informatica Cloud- IDMC experience
- Informatica PowerCenter - On-Prem experience
- Salesforce- cloud application experience
- Oracle, SQL Server – databases experience
- Linux Operating System experience
- Mainframe CA7 experience
Responsibilities:
- Building ETLs
- Building it with the Agile crew
- Design, develop, and implement ETL processes using Informatica PowerCenter, Informatica Cloud, or other ETL tools as required
- Work closely with stakeholders to gather business requirements and translate them into data integration solutions.
- from various source systems into data warehouses, data lakes, or other repositories.
- Optimize ETL processes for performance, scalability, and maintainability
- Perform data profiling and data validation to ensure high data quality
- Monitor and troubleshoot ETL jobs, ensuring that data is processed efficiently and errors are resolved promptly.
- Collaborate with the data architecture team to design optimal data models and data integration solutions
- Work on data migration, data cleansing, and data transformation processes.
- Create and maintain detailed technical documentation for ETL processes, mappings, workflows, and data sources
Why Work for ConsultUSA:
- ConsultUSA offers competitive salaries, major medical (PPO or HDHP w/ HSA), dental, and vision insurance plans, and 401k plan with immediate eligibility for both salary and hourly employees
- ConsultUSA hosts several outings and events, holiday and summer parties, and volunteer opportunities throughout the year for employees
- We will work with you to obtain training for in-demand technologies and prepare you for industry-recognized certification exams
- ConsultUSA offers Business Analysis and Project Management training through our Project Management Institute (PMI)® award-winning sister company, PMCentersUSA
How to Apply:
To submit your application, please click the “Apply Now” button located at the top and bottom of the page.
ConsultUSA is committed to providing equal employment opportunities (EEO) to all qualified employees and applicants for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, age, disability, genetic information, marital status, pregnancy, ancestry, or status as a covered veteran as well as any other prohibited criteria under any applicable federal, state, and local laws applicable to ConsultUSA.
For a complete listing of all ConsultUSA jobs please visit www.consultusa.com
