SUMMARY:

• Over 11 years’ experience in DWH ETL Development and testing area mainly in:
• Data warehouse Testing/BI ( ETL, BI )
• Data warehousing Datamart and Report Development using Tableau as BI tool and Informatica as ETL .
• Strong experience of development of Data warehousing application using Informatica as ETL tool and BOXI as reporting tool.
• Data processing knowledge in designing and implementing Data Warehouse applications, mainly Transformation processes using ETL tool Informatica Power Center 6.x, 7.x and 8.x etc.
• Thorough knowledge on Data warehouse concepts like Star schema, Snowflake schema, Fact constellation, Data Marts, ODS, Dimension and Fact tables.
• Strong experience of preparing SQL queries for performing ETL, Database, Migration, Data Comparison, Reports (SSRS, BO, Cognos) testings
• Good experience in formulating test strategies for Functional & BI projects (ETL, Data Migration, Reports)
• Experience in analyzing functional requirements and breaking them into high level & low level scenarios
• Good experience in preparing test data covering all types of scenarios for ETL, DWH, Reports testing
• Testing of job scheduling using control - m, job dependency & debugging the failures
• Have around 4 years of Team Lead experience and managed geographically distributed team of 10 members
• As an lead, performed end to end STLC activities encompassing On boarding, Estimation, Planning, Execution, Monitoring and Closure phases
• Worked in domains like Insurance,Investment Banking, Finance & Securities and Capital Markets

TECHNICAL SKILLS:

DWH Tools: Informatica ETL, Power Designer as Data Modeling tool, Control-m

Databases: SQL Server, Oracle, DB2.

Reporting Tools: Tableau

Database Tools: SQL Developer, TOAD

Test Management Tool: Quality Centre, JIRA, Clear Quest

Configuration Management: VSS, Clear Case, SharePointLanguages & Scripting: HTML, CSS, XML, PL/SQL

Test Tools: Test Complete, QTPOperating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Associate technical Specialist

• Preparing estimates for JIRA items for every release
• Understanding the requirements, preparing the high level test scenarios (positive, negative, exceptional) and writing SQL queries for validating the data against the mapplets in IDQ
• Pre-validation checks on feed files from UNIX, file validation, file load and file archival
• Preparing test feeds for validating the source filter conditions, delta checks (SCD type 2 checks) etc
• Identifying the test data requirements and preparing test data for validating functionalities like transformation, duplicates, delta loads, rejection, fuzzy match, trust matrix-linkages
• Data Quality analysis, ETL testing, Control-m testing, standardization & cleansing, matching and linking, fuzzy matches, workflow dependencies and testing, SCD Type 2 checks, de-duplication etc
• Control-m job scheduling & testing, job dependency & debugging the failures
• Sending test progress report to client and all stakeholders

Confidential

Associate technical Specialist

• Preparing estimates for JIRA items for every release
• Understanding the requirements, preparing the high level test scenarios (positive, negative, exceptional) and writing SQL queries for validating the data against the mapplets in IDQ
• Pre-validation checks on feed files from UNIX, file validation, file load and file archival
• Preparing test feeds for validating the source filter conditions, delta checks (SCD type 2 checks) etc
• Identifying the test data requirements and preparing test data for validating functionalities like transformation, duplicates, delta loads, rejection, fuzzy match, trust matrix-linkages
• Data Quality analysis, ETL testing, Control-m testing, standardization & cleansing, matching and linking, fuzzy matches, workflow dependencies and testing, SCD Type 2 checks, de-duplication etc
• Control-m job scheduling & testing, job dependency & debugging the failures
• Sending test progress report to client and all stakeholders

Confidential

Senior Software Engineer

Responsibilities:

• Preparing & uploading the test data as per test scenarios for Pre landing schema to validate the ETL mapping & transformation rules
• Preparing the test scenarios and writing SQL queries for validating the mapping & transformation rules in ETL, validating data in Landing, Staging and Base Objects, validate the match functionality
• Validating the source and target counts, lookups, cleanse functions, data duplication etc
• Sending test progress report to client and all stakeholders
• Publishing the project Lessons Learned document among stakeholde
• Preparing the high level test scenarios (positive, negative, exceptional) and writing complex SQL queries for validating the mapping & transformation rules in ETL, testing stored procedures
• Identifying accelerators for test activities like data comparison & ETL testing
• Sending test progress report to client and all stakeholders.

Confidential

ETL Developer

• Develop/Modify Informatica Mappings, Workflows, and different session tasks.
• Worked extensively on different types of transformations like Expression, Filter, Aggregator, Rank, Lookup, Update Strategy, Sequence Generator and Joiner etc.
• Created and maintained Informatica Mappings.
• Prepare UTR, TDS & Unit Test Cases for the Mappings.
• Sort out the internal Defects of Developments.
• Testing - unit testing & integration testing.
• Worked on migration of mappings & workflows across environments
• Tuning the Informatica Code for Optimum Performance.
• Performance tuning of mappings as per production timeline for different upstream and downstream.

Confidential

Analyst Programmer

• Worked extensively on different types of transformations like Expression, Filter, Aggregator, Rank, Lookup, Update Strategy, Sequence Generator and Joiner etc.
• Created and maintained Informatica Mappings.
• Prepare UTR, TDS & Unit Test Cases for the Mappings.
• Sort out the internal Defects of Developments.
• Used Workflow Manager to create, schedule, execute, and monitor sessions and batches that perform source to target data loads.
• Created Reusable Transformations and Mapplets.
• Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Implemented Informatica Best Practice strategies while developing Transformations, Mappings and Mapplets using Informatica power Center.
• Created Sessions using Workflow Manager.
• Identifying & assessment of resources, allocation, on boarding, assigning roles & responsibilities
• Identifying learning & certification plans for team and executing them
• Performing team appraisals, setting goals & objectives, providing constructive feedback with improvement areas
• Good understanding of stakeholder management
• Identifying risks, escalating on time with appropriate stakeholders and mitigating them
• Performing project assessment on process areas & implementing solutions for improvement

Confidential

ETL Developer

• Study the Requirements for Phase I & II
• Develop/Modify Informatica Mappings, Workflows, and different session tasks
• Worked extensively on different types of transformations like Expression, Filter, Aggregator, Rank, Lookup
• Preparing scenarios and writing test cases for E2E testing of the application
• Writing medium to complex SQL queries using Business Rules for comparing data against Teradata database
• Exclusively worked on validating the new monthly statement with the current statement from OnDemand
• Querying EDW for the required account classifications/account types and transactions as needed
• Validating the transaction codes for Activity section, identifying the missing transactions in new statements
• Defect management with onsite lead and QA manager
• Preparing different status reports for E2E testing
• Preparing module-wise induction document for project
• Coordinated and mentored new team members

Confidential, Chicago

ETL Developer

• Study the Requirements for different work packets
• Preparing traceability matrix and writing test cases for Functional, Integration, Systems, GUI and Localization testing(English and German versions)
• Test data creation for financial ratios and performance data of various financial instruments
• Querying SQL Server, preparation of complex SQL queries for test execution
• Closely worked with Dev team for successfully deploying first application build for QA team
• Defect management and escalation
• Coordinated with developers, mentored new team members