SUMMARY:

• To become a part of a professional organization where I can apply my ideas and enhance my skills.
• Qualified professional, has 8+ years of extensive IT Experience in Data Warehousing in Banking Services and communications domain.
• Have good understanding of Testing Methodologies, Software Test Life Cycle and Software Development Life cycle including Waterfall and Agile
• A large amount of experience gathering user requirements and translating them into technical and system specifications. Managing clients, vendors, and partner relationships.
• 8 Years and 4 months experience in Big Data Testing, ETL/DW Testing, UNIX Developer, Informatica Developer, SOAP, REST API, DataStage Testing.
• Proficient in programming languages UNIX, Perl, Python & awk.
• Experienced in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load ETL routines for migrating data from non - relational or source relational to target relational.
• Proficient in developing Entity-Relationship diagrams, Dimensional Modeling, Star/Snow Flake Schema Designs and Expert in modeling Transactional Databases and Data Warehouse.
• Excellent communication skills in handling cross functional teams, coordinating technical support, promoting data analysis, conducting performance tuning and supervised data collection guides.

TECHNICAL SKILLS:

Programming languages: UNIX,Perl,Python,awk.

Database Systems: Oracle, MongoDB,Hive

ETL Tool: Informatica 9.6, Datastage 9.1

PROFESSIONAL EXPERIENCE:

Big Data Tester - Associate

Confidential, Schaumburg, Illinois

Responsibilities:

• Working as a Big Data tester for EVP project where we track each customer viewership information(50 millions/daily) from different source system.
• UNIX,Hive,Spark.
• Responsible for validating the data comes from different sources and ensure all the data mapping logic works as per the functional specification and verify the target data which we share it to business users for their analysis.

Test Designer - Associate

Confidential, Schaumburg, Illinois

Responsibilities:

• Worked as UNIX developer for video bill generation project where we display video bills to customers to understand the Confidential & Confidential mobile in a better way.
• Tools Used - UNIX,Oracle
• Prepared an automation script in UNIX to validate the Informatica sessions, mappings & workflows between two repositories to identify the differences. It is mainly used in hot swap for each release deployments. Tools Used - Informatica, UNIX.

ETL Tester/ UNIX Developer - Associate

Confidential

Responsibilities:

• Worked as ETL tester for a DataStage migration project where we involved in migration from Datastage V7.5,8.1 to 9.1. Tools Used - DataStage, UNIX.
• Prepared an automation script in UNIX to trigger the jobs in a sequential way and monitor the status of each job. If there is any failure in the mid-way of execution, it has the provision to start from last successful point.

ETL Tester - Senior Test Engineer

Confidential

Responsibilities:

• Roles/Responsibilities mainly included writing test cases based on requirements and creating test plan and giving formal walkthrough of the test cases to clients and interact with them to execute the test cases.
• Involved in system and regression testing. Tools Used - UNIX, Oracle,Syncsort,Netezza.