Sr. Informatica Engineer

Job Description

The Sr Informatica Administrator will be part of the team that supports a growing Master Data Management platform using Informatica, Azure SQL Services, classic SQL Servers and other data platforms.

Responsibilities
• Administering the Informatica cloud platform
• Making changes to cleansing rules, flow changes, schema changes, and implementing new entities
• Monitor performance, troubleshoot, and tune Informatica processes
• Will be responsible for 24x7 support
• Work with Informatica vendor on any issues that arise
• Support the data development team as needed

Qualifications
• Excellent oral and written English communication skills
• Specifically needs to be able to communicate well on phone calls
• Must be able to thrive under pressure and have a strong sense of ownership and responsibility for the project
• Minimum of 3-5 years of experience in the administration, architecture, design, and development of Informatica's data integration tools
• Informatica experience must include working with large mission critical data systems (multiple terabytes in size with millions of rows processing per day)
• Must be able to demonstrate mastery of quickly debugging and resolving issues that can arise with Informatica programs.
• Minimum 2 full lifecycle project experience with small development groups, e.g., leading ground up development of Informatica standards in one or more previous projects.
• Demonstrated ability to navigate through organizational and technical uncertainty
• Strong Customer MDM resource with hands-on in Informatica Customer 360 or Informatica multi domain. This will be a hands-on role w.r.to development
• Strong knowledge on Design, develop, test informatica processes and deploy informatica objects using deployment groups/github.
• • Develop/Implement the coding of Informatica mappings for different stages of ETL. Move staging table to the target table.
• Design, code, unit test ETL packages, triggers, and stored procedures, views, SQL transactions
• Utilize Informatica repository manager, designer, workflow manager & workflow monitor, to manage and administer ETL jobs
• Design, schedule, execute and monitor ETL jobs, including necessary exception handling & balance and control measures
• Perform troubleshooting, debugging, and performance tuning
• Create, test and refine SQL queries to support data profiling and data management
• Perform data profiling, data standardization, data transformations, data loads.
• Perform detailed data profiling and end-to-end data management analysis to understand data issues, and to identify potential options to resolve issues.
• Support phases of the project lifecycle including requirements gathering, analysis, design, development, testing, deployment, support, and documentation
• Analyze, document and define data management processes, both batch and real-time.
• Create clear deliverable materials for a range of recipients including technical teams, business teams, project leads and executives.

Preferred Qualifications
• Fluency with business concepts related to relational and dimensional data models
• BA/BS in computer science or equivalent experience
• Experience with large scale database application like Exadata would be a plus

Jobcode: Reference SBJ-g4mpp7-3-137-171-121-42 in your application.