Informatica Data Engineer

Informatica Data Engineer

Works with client management to identify and specify business requirements and processes for diverse development platforms, computing environments e.g., host based, distributed systems, client server, software, hardware, technologies and tools. Formulates logical statements of business problems and devises, tests and implements efficient, cost-effective application program solutions e.g., codes and or reuses existing code through the use of program development software alternatives and or integrates purchased solutions. Works independently, receives minimal guidance. Acts as a resource for colleagues with less experience. Solves complex problems takes a new perspective using existing solutions.

Responsibilities:

• Participate in team agile tasks and sessions such as story estimation, sprint planning demonstrations, and retrospectives.
• Establishes IDQ environments (Dev, Staging & Test) according to project requirements
• Design and develop data quality rules to evaluate and verify data transformations; update ETL scripts and data mappings to improve data migration activities using Informatica, Oracle, SQL, and other technologies.
• Evaluate legacy databases and ERD's to determine high confidence data quality and best transformation strategies to next generation data model
• Support data traceability, integrity and validation documentation along with ETL code, data dictionaries, profiles and script repository management.
• Work closely with Data Architects and Test Specialist to verify business rules and develop test plans and test scripts for data validation.
• Establish a portal for data analysts and customer to evaluate data anomalies /exceptions and data migration verifications.
• Develop reports to display validation and review progress; in addition to generating data cleansing and exception management reports.
• Work effectively with teammates; collaborate on shared work products and related tasks to ensure best solution derived.
• Expertise in Informatica (v.9/10) Data Quality (IDQ), Oracle RDBMS
• Bachelor’s Degree or an equivalent combination of education and training that provides the required knowledge, skills and abilities.
• Strong interpersonal skills

Qualifications/ Skills:

BS degree with 4+ years in SQL experience and 5+ years overall hands on Informatica Data Quality (IDQ) development experience.

Strong understanding on Data Profiling / Data Analyst tool.

Skilled and experienced in Informatica ETL tool suite including PowerCenter designer, workflow, monitoring and repository services.

Proficient with Informatica ETL Integration using Teradata, Oracle, Mainframe, and SQL Server databases.

Understanding of reusability, parameterization, and workflow design concepts.

Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members.

Strong Programing and SQL skills

Informatica Admin experience is a plus.

Excellent oral and written communication and interpersonal skills.

Strong organizational, multi-tasking, and time-management skills preferred.

Ability to work independently or within a team for problem resolution.

Strong knowledge of Microsoft Office tool set.