Sr Informatica ETL Developer
About The Position
This role is for a Sr Informatica ETL Developer responsible for detailed design, development, unit testing, and support for integration testing. The developer will produce scalable and flexible, high-quality code that satisfies both functional and non-functional requirements, using secure development best practices and design patterns. They will also be responsible for creating and updating design and systems documentation, process and data flow diagrams, and cross-training team members. The role involves analyzing and translating business requirements into technical designs, resolving technical issues, and collaborating with project teams and business users. Support for functional and performance testing is also required, working closely with the technical delivery lead on project activities and ensuring timely implementation of assigned work within project schedules.
Requirements
- Informatica, Oracle, MYSQL, Cloudera DataLake/SQL, BDM, IDQ, IICS
- DBMS: Oracle, MYSQL, Cloudera DataLake/SQL experience
- Strong experience with Informatica programming across three main products BDM, Power Center and IICS
- 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
- Minimum of 7+ years overall IT experience
- Experienced in both working with QA teams for integration testing as well as being responsible for testing own code
Nice To Haves
- IDQ and ICRT experience is a plus
- Additonal experience a plus: Axon
- Strong Automotive OEM experience a plus
- Experienced in waterfall, iterative, and agile methodologies
Responsibilities
- 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
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
