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