ETL QA Tester Resume

SUMMARY:

Over 8 years of Experience in Design, Development and Testing of Data warehousing, Data Integration, Data Migration and Data Quality projects. Using ETL tool Informatica Power center 10/9.x/8.x/7/x, Informatica Developer (IDQ) etc.
Excellent experience in Extraction, Transformation and Loading (ETL) of data from Multiple Sources systems like Oracle, SQL server, Mainframe, DB2, Flat Files, XML, etc into Data Warehouse environment.
Proficient in using Informatica powercenter tools in design and development of Mappings, Mapplets, Sessions and workflows
Sound Knowledge of Datawarehouse concepts with Dimensional modeling using Star schema and snowflake schema.
Good Understanding of Logical data model and Physical data model using Erwin, in designing data warehouse Architecture.
Strong SQL Skills in the design and development of data scripts.
Proficient in developing the scripts using PL/SQL in handling the complex logic in the ETL process in working with SQL Skills.
Experience in Performance tuning the Informatica ETL Process in Analyzing the Session logs and improving the Sessions performance.
Developed complex mappings in Informatica designer to get data from various sources using many transformations such as Source Qualifier, Lookup, Expression, Router, Normalizer, Joiner, Update Strategy, Aggregator, Sorter, Sequence Generator etc.
Experience with using Informatica Metadata manager in Data lineage and Repository Management.
Good Experience of the Informatica Data Quality (IDQ) in cleansing the data using Informatica developer/Analyst.
Good Understanding of Informatica MDM concept in design and configuration of Master data.
Good Understanding of Informatica metadata manager and data lineage
Strong in analytical and conceptual skills in database design and development of Tables using Oracle 12 c/11g and MS SQL Server 2012/2008
Strong experience in Tuning of SQL scripts to improve the performance of the ETL Process.
Proficient in developing SQL, T-SQL, PL/SQL packages, stored procedures and Triggers.
Good Understanding in using MultiLoad, FastLoad, FastExport, Tpump and BTEQ in loading the data into Teradata.
Strong Unix scripting skills in handling the files to perform sanity checks like data file availability, checking header/trailer records, row counts, processing status and scheduling the Batch jobs using PMCMD commands for calling Batches and Sessions.
Good conceptual knowledge of Hadoop and Informatica BDM platform.
Good working experience with the reporting tools Oracle BI, Tableau, Business Objects and Cognos.
Good Experience in interacting with Business users to understand the business requirements.
Team player and self-starter with good communication skills and ability to work independently and as part of a team.

TECHNICAL SKILLS:ETL: Informatica Power Center 10.1/9.6, PWX 8.1, IDQ, MDM, IDD, BDE, DVO, MS SSIS 2012

OLAP: OBIEE, Cognos, SAP Business Objects, MS Power BI, Tableau.

Big Data: Informatica BDM, Hive, Hadoop, Yarn, HDFS, Map Reduce, Cloudera.

Databases: Sybase 11, Exadata, Oracle 12c/11g, MS SQL Server 2012, DB2 V 8.0, Teradata, Netezza.

Modeling: Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables, ERWIN 4.1.

Scripting: SQL, PL/SQL, COBOL, Korn Shell Scripting, HTML, VBScript, JavaScript, XML, Java, JDK.

Tools: FTP Pro, Quest Central for DB2, TOAD, SQL Navigator, SQL*Loader, Visual Interdev 6.0, Autosys, MS Visio, Expresso, Microsoft SharePoint, BMC Remedy, Service Now.

OS: UNIX (Sun-Solaris, AIX 4.3/4.2 HP/UX), Windows Server 2012, Linux.

Ver: CVS, PVCS, MS Visual SourceSafe, IBM Rational Clear Case, Serena Dimensions.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship