NAKUL PATEL

**** *** ******, ********, ** *****

215-***-****

adhdf0@r.postjobfree.com

PROFESSIONAL SUMMARY:

Highly accomplished ETL Informatica developer with 4+ years of extensive IT experience in business analysis, design, development, testing, defect resolution, QA testing, implementation, user training, and process improvement in the retail industry. CORE QUALIFICATIONS:

● Proficient in Informatica 8.x/9.x/PowerCenter version 10, Oracle, DB2, SQL, Teradata & Unix Shell. Develop and execute detailed Informatica related functional, performance, integration and regression test cases, and documentation.

● Strong experience in Extraction, Transformation, and Loading(ETL) data from various sources into Data Warehouse and Data Mart using Informatica and Microsoft Azure Data Lake.

● Worked with UNIX shell scripts and automation of the ETL process using UNIX shell scripting.

● Experience working with relational databases such as Teradata, DB2, Oracle, and SQL Server.

● Strong Data Warehousing ETL experience of Informatica, PowerCenter, Mapping Designer, Repository Manager, and Workflow Manager.

● Work closely with software developers/project owners and BAs' to develop and execute thorough test suites in all phases of the software development cycle.

● Analyze and understand the Informatica Mappings/Workflows developed by offshore teams.

● Work closely with software developers/ project managers and BA's to develop and execute thorough test suites in all phases of software development cycle.

● Execute manual test cases, analyze results, and track defects in ALM. In addition, verify fixes and perform follow-up work to resolve issues.

● Responsible for Unit testing and Integration testing of mappings and workflows.

● Deployed ETL components code into multiple environments as per the approval received.

● Ability to learn and implement new systems when necessary.

● Excellent interpersonal and communication skills, and worked with managers, business people, and developers across multiple disciplines.

● Strong experience in agile methodologies and worked in agile projects.

● Hands-on experience in resolving on-going maintenance issues, bug fixes, and production support during on call support rotation schedule.

● Taken courses online: Google Cloud, BigQuery, Microsoft Azure Data Lake using spark. SKILLS:

Languages/Frameworks/Environments:Informatica Power Center, SQL, Unix, Databases: SQL Server, DB2, Oracle, Teradata

Tools:Jenkins, Git, AQT, Teradata Studio, Azure Data Lake, Stonebranch EXPERIENCE:

MAY 2016 - AUGUST 2020

APPLICATION DEVELOPER, QVC IN WEST CHESTER, PA

Enterprise Datawarehouse Group

Informatica developer for the Enterprise Data Warehouse ETL projects

(Informatica PowerCenter)- Involved as a primary ETL developing during the analysis, planning, design, development, and implementation stages of various projects.

● Develop and Design ETL test cases, scenarios, and scripts to ensure quality Data Warehouse using pushdown optimization.

● Conducting hands on functional, and system integration testing, report, track and follow up on issues in a timely manner.

● Worked closed with the business analytic, IT leads and other developers in analyzing business requirements and translating them into technical design specifications.

● Assisted in architecture design of new data warehouse and ETL processes.

● Documented and reviewed all test cases and procedures in Unit Test reviews with senior management.

● Design and develop strategic test plans, Test Cases/Test Scripts, Test Scenarios, Test Reports. Effective time Management skills and consistent ability to meet client’s deadline.

● Created SQL queries, analyzing data and documenting results. EDUCATION:

Bachelor of Arts : Information Science and Technology Philadelphia, PA Temple University May 2016 - Philadelphia, PA

REFERENCE:

Sridhar Ranganathan - EDW Manager at QVC

Contact: adhdf0@r.postjobfree.com - 484-***-**** George Wentzel - Application Developer at QVC

Contact: adhdf0@r.postjobfree.com - 267-***-****

Contact this candidate