ETL Informatica Developer

iBrain Technologies is an experienced IT Consulting and Service delivery company headquartered in St Louis MO. we partner with our clients who seek strategic talent and to assist those candidates looking for their next career opportunity. With over 17 years' experience in the field, we approach each partnership with a commitment to our clients to identify the right fit and to deliver world class candidate experience throughout the recruiting lifecycle. We look forward to working with you.

Essential Functions

• Design, develop, and implement ETL processes using industry best practices and standards.
• Optimize ETL processes for performance, scalability, and reliability.
• Troubleshoot and resolve issues related to data integration, ETL processes, and data quality.

Develop standards and processes to support and facilitate integration projects and initiatives.

• Develop data mappings, transformation rules, and data workflows to meet business needs.
• Work with stakeholders throughout the organization to identify opportunities for leveraging company data to drive business solutions.
• Document ETL processes, data mappings, and system configurations.

Document, manage, and report on project risks and opportunities.

Prioritizes tasks and meets project deadlines in a fast-paced work environment.

Conform with all company policies and procedures.

Required Knowledge, Skills, Abilities (KSAs)

• Experience with Oracle Data Lake Architecture will be preferred.
• Experience on multi-cloud environments will be preferred.
• Experience with ETL tools (Pentaho and or Oracle Data integration preferable)
• Solid understanding of data warehousing concepts and methodologies.
• Experience with business and technical requirements analysis, business process modeling/mapping and methodology development, and data mapping.
• Experience working with data quality issues and providing remedies to those issues.
• Experience querying databases and using statistical computer languages: Python, SQL etc.
• Demonstrate understanding and experience with technical systems, datasets, data warehouses, and data analysis techniques
• Strong analytical skills: ability to build quick estimates using back-of-the-envelope analysis, structure (and, if needed, execute) more complex analyses, pull together business cases, navigate multidimensional sets of tradeoffs. Above all, the job calls for comfort with data ability to manipulate it, question its validity, interpret it, and develop recommendations based on it

Required Education, Certifications/ Licenses, Related Experience

• Bachelor's degree
• At least 10 years or more total software development, architecture, and solution design experience
• At least 5 years of hands on ETL tools (Pentaho and or Oracle Data integration preferable)
• At least 5 years of hands on, ETL and data analysis experience.
• At least 3 years' experience with Cloud Native technologies
• At least 2 years' experience in design, implementation, deployment, and support of public cloud services and infrastructure (Aws, Oracle platform)