Responsible for requirements analysis, design, development, data profiling and testing using Informatica, Teradata, UNIX Shell Scripts, PL/SQL. Develop complex ETL mappings in Informatica PowerCenter Designer using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Expression, Normalizer, Sequence Generator and Update Strategy, data standardization, address validator. Design and develop data validation processes using Informatica Data Quality framework. Perform data analysis and data profiling using SQL and Informatica Data Explorer on various source systems including Oracle, SQL Server, Flat files, and Teradata. Use Informatica to load the data from different sources to target systems as per the mapping requirements. Validate the status of the jobs in Informatica workflow monitor and improve the performance of the jobs. Develop test cases based on ETL mappings document. Test ETL mappings and ensure that the mappings do the transformation as expected. Design, develop exception and error handling through data governance to leverage data stewardship for minimal anomalies. Interact with Data modelers and DBAs on data architecture optimization for ETL performance. Write complex PL/SQL stored procedures, SQL queries to make sure the data is populated in Data Warehouse according to business rules. Develop and manage UNIX Shell Scripts to automate ETL pipeline. Collaborate with business users in testing new functionality, documenting and retaining ETL knowledge.

Location: Will work in Irving, Texas and/or various client sites throughout the United States. Must be willing to travel and/or relocate.