Sr Informatica ETL Developer

About Apexon:

Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation. Apexon brings together distinct core competencies - in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences - to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients' toughest technology problems, and a commitment to continuous improvement. Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence of 15 offices (and 10 delivery centers) across four continents.

We enable

Job Role: Sr Informatica ETL Developer II

Location : Auburn Hills, MI

Responsible for detailed design, development/unit testing and support for integration testing

Experienced in both working with QA teams for integration testing as well as being responsible for testing own work (i.e. QA is not always involved in every task - ability to thoroughly test their own code is mandatory)

Produce scalable and flexible, high-quality code that satisfies both the functional and non-functional requirements

Identify technical issues & coordinate the resolution of these issues with technical lead team members

Uses secure development best practices and design patterns

Create or update design and systems documentation for developed or modified services or programs

Create process and data flow diagrams for data movement capture

Cross train team members for full knowledge coverage on team

Analyze and translate business requirements to technical design

Analyze and resolve technical issues

Collaborate/communicate with project team and business users as required

Support functional testing and performance testing

Works with technical delivery lead on project activities

Ensure assigned work is implemented within project schedules

Includes all developer skills, plus the following.

Minimum of 7+ years overall IT experience

Strong Automotive OEM experience a plus

Experienced in waterfall, iterative, and agile methodologies

Informatica

DBMS: Oracle, MYSQL, Cloudera DataLake/SQL experience

Strong experience with Informatica programming across three main products BDM, Power Center and IICS - IDQ and ICRT experience is a plus.

Skilled in Microsoft Office applications (Visio, Word, Excel, Access)

Experience in both Unix and Windows platforms

Design and develop Informatica workflows to exchange data with the Oracle databases, Salesforce, Data Lake or other operational or warehouse data stores

Be able to create or modify Perl scripts for job control and process flow

Additonal experience a plus: Axon"

Our Commitment to Diversity & Inclusion:

Did you know that Apexon has been Certified by Great Place To Work , the global authority on workplace culture, in each of the three regions in which it operates: USA (for the fourth time in 2023), India (seven consecutive certifications as of 2023), and the UK.Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. You can read about our Job Applicant Privacy policy here Job Applicant Privacy Policy

Our Perks and Benefits:

Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones. As an Apexon Associate, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance.

We also offer:

o Health Insurance with Dental & Vision

o 401K Plan

o Life Insurance, STD & LTD

o Paid Vacations & Holidays

o Paid Parental Leave

o FSA Dependent & Limited Purpose care