Manager Developer
Resume:
NAKUL PATEL
**** *** ******, ********, ** *****
************@*****.***
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: *******.***********@***.*** - 484-***-**** George Wentzel - Application Developer at QVC
Contact: ******.*******@***.*** - 267-***-****
Contact this candidate