IICS ETL Developer

Job Location: Cincinnati, OH (To be considered you must reside in the Cincinnati region or be willing to travel to Cincinnati 50% of the time.)

Join our team

Centric Consulting is a management consulting firm that guides clients in the search for answers to complex digital, business and technology problems. We help clients conquer change, optimize processes, elevate technology, and best compete in a digital world. Our core purpose is simple: every day we strive to provide unmatched customer and employee experiences and foster a culture of respect, diversity, and transparency. Headquartered in Ohio, with locations across the country and India, Centric has earned annual recognition by Forbes as one of America's Best Management Consulting Firms since 2016. Visit our website to learn more.

Our Cincinnati business unit is passionate about making a positive impact in the community. We strive to live our Centric core values and embed them in the work we do for our clients and in our corporate citizenship role. We're looking for an ETL Developer to join our growing team.

In this role, you will:

• Coordinate technical design sessions with the Data Transformation Analyst
• Build ETL environment based on business requirements document and ETL design specifications within IICS
• Document all Extracts, Transformations, and Loads that are created
• Execute in performance tuning of targets, sources, mappings, and sessions within IICS.
• Create and monitor sessions using workflow manager and workflow monitor.
• Schedule ETL jobs and Automate Error Handling Scripts
• Participate in Code Reviews with Clients
• Write complex SQL scripts to avoid unnecessary Lookups to improve the performance with large sets of data
• Create Stored Procedures and Macros as necessary
• Document and update Physical Architecture diagrams for Development, Test, and Production
• Analyze and execute the test cases for various phases of Testing - integration, regression, and user
• Use Erwin for Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.
• Perform Impact Analysis of the changes done to the existing mappings and provided the feedback
• Participate in the maintenance and enhancements for VMware Entitlements related data mart.
• Optimize and implement backup and recovery procedures
• Create mappings using reusable components like worklets, mapplets using other reusable transformations.
• Worked on Informatica Source Analyzer, Mapping Designer & Mapplet, and Transformations.
• Optimize Data Models and Summary Tables to support self-service

A successful candidate will have the following characteristics:

Required Qualifications:

• The major qualification is the ETL Developer should have experience with IICS (the cloud version of Informatica).

General Qualifications:

• Strong SQL skills with and understanding of other query languages
• Proficiency with multiple ETL tools and data storage environments
• Experience working in a Cloud based solution
• Ability to integrate with Security protocols (SSO, Multi- Factor)
• Proven capacity of troubleshooting issues across multiple departments and vendors
• Ability to adapt in a fast-paced flexible environment
• Document and update project Change Control System
• 5+ years of experience around the skills mentioned above

What makes Centric different?

• Special Culture - Our people make us different. We have highly talented, intelligent individuals across a broad variety of disciplines - who are eager to learn from you and share their own expertise. We embrace fresh perspectives and each other. Don't take our word for it - check us out on Glassdoor , Facebook , Twitter or Instagram to get a glimpse inside what makes us unique.
• Impact - We think of ourselves as a big company with a small company feel - a local player with global reach that combines business, technology and industry expertise.
• Unmatched Experiences - We are allowed to be ourselves here. We are encouraged to be human. It's at the root of who we are as a firm and why we're here .
• Diversity, Equity, and Inclusion - We believe a diverse, inclusive, and equitable work environment is essential to the work we do. We continually strive to ensure our company is a place where all people feel like they belong and are respected and valued regardless of who they are, where they are from, and what experiences they've had. Beyond being the right thing to do, it is a business imperative that is fundamental to how we bring our mission and values to life. We believe a Centric Together work environment is essential to what we do.
• Innovation - We value passion, determination, perseverance and innovation . We are inspired because we believe in what we are doing and where we are going.
• Passion for the greater good - We are steadfast in our devotion to the communities we serve and in actively promoting employee involvement in community improvement projects .

Our core purpose at Centric Consulting is to bring unmatched experiences to clients and employees. These aren't just words we use - it's how we became a company and who we are today. Providing an unmatched experience means we approach each other as human beings and lead with empathy and humility. It means we work diligently to ensure our company is a place where everyone can create a sense of belonging and feel respected for who they are.

We know that creating and sustaining an authentically welcoming culture requires that we all play a part in fostering diversity, equity, and inclusion , from our business practice to how we show up for employees and communities. At Centric, we seek out and embrace candidates of all backgrounds and identities who have a hunger for learning, collaborating, and generating unmatched experiences. This is how we bring our mission and core values to life, working together to provide the highest value and quality services to our clients while enabling our employees to reach their full potential.