We provide IT Staff Augmentation Services!

Etl Qa Lead Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Result oriented individual with a verifiable track record in driving change, proposing efficient solutions and exceeding client expectations.
  • Reputed for exercising initiative, accepting challenges, analysing alternatives to overcome obstacles and facilitate effective service solutions by managing clients, stakeholders and the team.
  • Around 12 years of relevant IT experience in which 4+ years as Database Developer & 8+ years as Test Engineer
  • Masters in Computer Applications and multinational experience - United States, Germany and India
  • Diverse work experience in development of Oracle Database and Crystal report and Testing in ETL, Big Data, Crystal Report and GUI.
  • Demonstrable experience in ETL testing and Database testing
  • Expert in BIGDATA technologies like HIVE/IMPALA using HADOOP and Informatica
  • Excellent Knowledge in Database systems like Oracle 12C, SQL SERVER and Proven skills in writing Complex HQL queries, PL/SQL blocks, packages, procedures, functions and triggers
  • Well-versed with all stages of ETL testing process and solid understanding of relational data models and database objects
  • Skilled in transformation rules verification processes, data comparisons and validations and proficient in trouble shooting Data related issues
  • Extensive experience in ETL automation tool ICEDQ
  • Skilled in Smoke, Functional, Integration, Regression, End to End, UAT and GUI Testing.
  • Designed and Implemented ETL Automation Test suites at different functional types of testing.
  • Sound working experience in white box, black box and automation testing
  • Good knowledge on concepts of Data ware house, Data profiling and Data mining
  • Experience working with data integration and data migration projects
  • Strong knowledge of SDLC and STLC cycles and SDLC methodologies such as Agile Scrum, Water Fall
  • Excellent in Business Objects Crystal report development and validation
  • Demonstrable skill in troubleshooting live production issues
  • Understanding the Sprint goals and establishing team communication protocol, promote transparency in achieving sprint deliverables
  • Highlight internal/external dependencies within the Scrum Team and cross teams, escalating sprint impediments.
  • Collaborate with other Scrum Teams, Program Managers, PMO to adapt organizational process, recommend process improvements, learn industry best practices and implement standards.
  • Plan, develop, and maintain effective client relationship and proactively contacting them to maintain a consistent high level of service delivery.
  • Represent the requirements of the clients internally, and act as a subject matter expert in the products and services delivered to clients.
  • Demonstrable experience establishing and maintaining an effective working relationship with Stakeholders ensuring contract compliance and client satisfaction.
  • Proven skills and experience in leading, coaching, developing and mentoring team members in order to maximize performance and ensure that targets are achieved or exceeded.
  • Managing the workload within the area of operation, efficiently as per service level agreements through effective planning, prioritizing, training and employee engagement.
  • Demonstrated capacity to perform effectively under pressure and in the face of conflicting demands and competing interests, including delegating and prioritizing work appropriately.
  • Strong aptitude for technology with an ability to absorb complex technical concepts and communicate them to a non-technical audience.
  • Excellent communication and analytical skills and a demonstrated leadership quality to work collaboratively with testers, developers and other team members in executing the complex projects and in the overall enhancement of software product quality.
  • Proven analytical skills in conducting RCA
  • High level of attention to detail, creativity and innovation
  • Strong problem solving and analytical skills
  • Time management skills to plan, prioritize, organise and manage good verbal and written communication skills
  • Exceptional interpersonal and relationships building skills

AREAS OF EXPERTISE:

  • Big Data Testing
  • ETL Testing
  • Agile Scrum
  • Database development
  • Process improvement
  • Service Improvement
  • Product Management
  • Team Management
  • Leadership
  • Stakeholder Management
  • Resource Management
  • Relationship Management

TECHNICAL SKILLS:

RDBMS: Oracle 10g, Oracle 12c, MS Access, SQL Server 2000/2005

Database Tools: Hadoop 2.6.0,Beeline version 1.1.0, Impala Shell v2.7.0,Hue 3.1.1, Toad, PL/SQL Developer, SQL developer

ETL Tools: Informatica 9.1.0, Sqoop 1.4.6

Reporting Tools: Crystal Report XI, Silver light

Operating System: Windows, UNIX

Automation Tools: ICEDQ(ETL),STAS

Test/Defect Management Tools: HP ALM,QC, JIRA, Clear Quest, Test Director, TMS

Version Control: Clear case

Scripting Languages: VB Script, XML and HTML

Methodologies: Waterfall, V-Model, Agile

Programming Languages: C, C++, Java, .Net

GUI: Visual Basic 6

Web Technologies: ASP.NET, XML, ASP

Operating Systems: Windows, UNIX

ERP: JEEVES

Documentation: Process Flows, Test Plans, Test Scripts, Usability Analysis

Utility Tools: Confluence, MS Office Suite

Version Control: Visual Source safe(VSS), Clear case

Modelling: MS Visio

EXPERIENCE DETAILS:

Confidential

ETL QA Lead

Responsibilities:

  • Contribute in backlog grooming and estimating the User Stories and create subtasks in JIRA
  • Attend - sprint planning, backlog grooming, demo, retrospectives, daily scrum ceremonies stand-ups
  • Ensure that the sprint tasks are achieved by QA team and processes are followed
  • Help the teams remove testing related impediments, mediate through conflicts, identify risks and mitigate with help from Scrum team and QA manager
  • Ensure the readiness of the test environment and test data quality by doing manual data profiling.
  • Prepare test scenarios from business requirements and user stories, identify candidates for ETL Test automation using ICEDQ.
  • Develop and execute both manual and automation test scripts designed using SQLs /HQLs for Oracle Exadata, Hive and Impala
  • Validate the test result against the acceptance criteria defined in the user stories
  • Design and implement generic re-runnable manual and automation scripts for functional and regression testing
  • Review test scenarios and SQL test scripts with PO, Bas and scrum team for 100% requirement coverage and ensure that the comments are incorporated
  • Review scope changes in the business requirement and incorporate them in scripts
  • Synchronize the defects logged in HP ALM with JIRA and track them to closure as per the defined priorities.
  • Support Production release
  • The Total Advisor Platform (TAP) is designed to enhance the advisor’s core capabilities by delivering technology that will enable them to be the most productive advisors. TAP will accomplish this by migrating different applications into a single platform. Fidelity will thereby give advisors a fully integrated environment. TAP TD data project will receive heterogeneous feeds from their e-money custodians through data acquisition process. Staged acquired data in Hadoop will go through defined data consolidation process as per the business requirements. Then the consolidated data sets will go through the data reconciliation process and report any discrepancies as break.

Environment: Hadoop 2.6.0,Beeline version 1.1.0,Impala Shell v2.7.0,Hue 3.1.1, Oracle version 12c

ETL QA Lead

Confidential

Responsibilities:

  • Actively participate agile ceremonies like sprint planning, release planning backlog grooming
  • Conduct technical discussions with Bas, DAs and Scrum team
  • Negotiate with project team to arrive at workaround solutions where testing milestones not feasible in current sprint cycles
  • Develop and implement HQL scripts for validating ETL load b/w source and target, data cleansing and data scrubbing
  • Develop SQL scripts for verification for historical and incremental data loads as per the business requirements
  • Verify quality and integrity of data in each test environments
  • Validate the Data model and verify database objects such as schemas, tables, views and referential integrities
  • Decide and execute Regression/UAT testing and E2E testing as per the scope
  • Prepare test scenarios from business requirements and user stories, identify candidates for ETL Test automation using ICEDQ.
  • Conduct and participate for reviews for test scenarios, test scripts with scrum team/cross scrum teams and ensure 100% of requirements coverage
  • Create defects with appropriate severities for all the deviations from the requirements or expected behaviour and track them to closure
  • Update JIRA stories on daily basis and report the progress
  • TAP ASOF data processing deals with the transactions, positions and balances of different data sources like FBSI, FILI etc .ASOF transactions are those transactions happened in earlier period of time but received with current feed file. Those ASOF transactions are to be reconciled and adjusted as per the business requirements.
  • The business requirement for the ASOF data reconciliation is one among the most complicated process in TAP system.
  • Prepare/Review test scenarios and test cases /scripts generated for each user stories and ensure 100% test coverage
  • Create detailed sub task for each user stories and update them with daily progress
  • Synchronize the defects logged in HP ALM with JIRA and track them to closure as per the defined priority
  • Design and implement complex ETL Test scripts using hive/impala from the data mapping documents and functional Specification documents.
  • Ensure the readiness of the test environment and test data quality by doing manual data profiling.
  • Validate the pre and post load data using SQL scripts on Oracle Exadata, Hive and Impala for different schemas and Validate the test result against the business requirements
  • Develop HQL scripts for validation of Historical and incremental load as per the requirements
  • Review test scenarios and test scripts with scrum team.
  • Review scope changes in the business requirement and incorporate them in scripts
  • Conduct defect triage meeting on daily basis and decide the defect priorities with team.

ETL QA Lead

Confidential

Environment: Hadoop 2.6.0,Beeline version 1.1.0,Impala Shell v2.7.0,Hue 3.1.1, Oracle version 12c

Responsibilities:

  • Ensure that the sprint tasks are achieved and processes are followed in scrum team.
  • Contribute to sprint planning, backlog grooming, demo, retrospectives, daily scrum ceremonies stand-ups
  • Extensively use Informatica Workflow Manager to run the workflows.
  • Monitor the log files in Informatica Workflow Monitor.
  • Design SQL to confirm the data transfer from source to target.
  • Validate complex reports generated using Sliver light and Crystal Report
  • Validated the pre and post load data using SQL

Test Lead

Confidential

Environment: VS 2008, ASP.Net3.5, Oracle 10g, Informatica 9.1.0, Silverlight, Autosys, Crystal Report XI R2 and QC

Responsibilities:

  • Ramp up the test team from the scratch successfully.
  • Act as a single point of contact for all the database related activities
  • Document and maintain RTM
  • Participate in requirement for every new product release to identify the testable requirements and clarify unclear requirements and assumptions
  • Technical discussions with Business and Clients.
  • Design DFD’s and ER diagrams using Visio.
  • Coordinate with the front end design team to provide them with the necessary triggers, stored procedures and packages and the necessary insight into the data.
  • Create various business reports using Crystal report XI
  • Develop complex reports -- multi-functioned, leveled, summary functionality in main reports providing detailed drilldown through On Demand Sub-reports, dynamic link labeling, complex functions, cross-tabs, charts, etc.
  • Manage and contribute to Smoke/System Integration/Acceptance/System Tests activities.
  • Identified the End user scenario’s and design the test cases

DB Developer and Tester

Confidential

Environment: VS 2008, ASP.Net3.5, Oracle 10g, Crystal Report XI R2, IBM Clear Quest

Responsibilities:

  • Create Scripting standard document and baseline the processes followed in the team
  • Develop Automated Test scripts from manual test cases for functional and regression testing using STAS
  • Prepare Test environment setup.
  • Prepare the test scripts using VB script and customize the existing test scripts as per client request.
  • Perform Manual Testing and track defects, analyze and document using Test Director.
  • Maintain and Execute Automation scripts for every build release and Logging defects in Test Director
  • Smoke, Functionality, GUI, Database, Data Validation and Regression Testing of the application.
  • Power CC is a SCADA solution from Siemens and is deployed at the Control Centre. Power CC systems operate at the Region or country level, it connects to the individual substations present in the particular region/country and gives the consolidated view for the operator.

Environment: STAS, VB script, VBA

We'd love your feedback!