ETL Tester

Cognizant Technology Solutions Atlanta , GA 30301

Posted 2 weeks ago

Cognizant is looking for ETL Tester

Job Description:
ETL & BI Test Analyst.

Job summary:

  • Experience in data warehousing and BI testing with strong data analysis, SQL & data analytical skills. Very good understanding in ETL work flows and BI dashboards. Candidate should be very good in client facing, communication and presentation skills.

Responsibilities:

  • Requirement analysis and understanding of DWBI technical specification documents.

  • Analyze and understand the ETL work flows developed.

  • Validation of data transformations and perform End-to-End data validation for ETL & BI systems

  • Perform data analytical testing for the BI systems.

  • Should be strong in SQL and write complex SQL queries for validating business rules using Oracle/Teradata/SQL Server/DB2 scripts.

  • Understanding of the data model.

  • Develop Test strategy, test plan/design , execute test cases and defect management for the ETL & BI systems.

  • Good problem solving & debugging.

  • Client-facing, Presenting the deliverables with project stake holders.

Minimum Qualifications:

  • Minimum 6 years of experience in Data warehousing environment/projects

  • Minimum 4 years of experience in ETL & BI testing.

  • Strong knowledge on ETL and BI processes.

  • Strong in SQL preparation in Oracle/SQL Server/DB2/Teradata RDBMS

  • Strong in ETL data validation developed using Informatica /Abinitio /Datastage/SSIS ETL environments.

  • Strong in BI report validation developed using Cognos/Business Objects/Microstrategy/SSRS BI.

  • Exposure to DB tools : Toad/PL SQL developer/SQL Plus

  • Excellent communication, documentation and presentation skills

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr ETL / BI Tester

Cognizant Technology Solutions

Posted Yesterday

VIEW JOBS 3/22/2019 12:00:00 AM 2019-06-20T00:00 Architect Qualification: Bachelors in science , engineering or equivalent Responsibility: Technology Consulting * • Provide data to senior team members during consulting engagements. * • Create documents (eg preconsulting deck, recommendation deck etc) to be used during engagements. * • Analyze technology landscape, process, tools based on project objectives. * Knowledge Management & Capability Development. * • Conduct technical trainings/ Webinars to impart knowledge to relevant application development/ project teams. * • Create collaterals (eg case study, business value documents, summary etc). * • Post in Blogs / interviews to share expertise. * • Gain industry standard certifications on technology and architecture consulting. * • Contribute to knowledge repository and tools. * • Partner with Cognizant academy to create curriculum, assessments etc and conduct training. * • Organize project level KT sessions for new team members. * Requirement gathering and Analysis. * • Understand the functional and nonfunctional requirement. * • Collect nonfunctional requirements (such as response time, throughput numbers, user load, etc) through discussions with SMEs, business users. * Solution Definition & Design. * • Prepare low level design and common frameworks. * • Identify and conduct design of complex subcomponents /module in collaboration with project team, architects and client SME. * • Present the detailed design documents to relevant stakeholders and seek feedback. * • Undertake project specific Proof of Concepts activities to validate technical feasibility with guidance from the Application Architect. * • Support performance testing and resolve deadlocks on NFRs by implementing the best optimized solution and resolve performance issues. * Project Management Support. * • Share technical inputs from project planning perspective with Test Lead/Architect. * • Help project managers to understand the technical risks and comeup with mitigation strategies. * Business and Technical Research. * • Understand application architecture and its criticality. * • Analyze and assess tools (internal/external) on specific parameters. * • Support Architect/Sr Architect in drafting recommendations based on findings of Proof Of Concept. * • Analyze the market trends and identify new developments in existing technologies (eg methodologies, frameworks, accelerators etc). * • Document these new developments (eg report, white paper, national/ international publications) in order to build team capabilities. * Testing Support. * • Suggest test automation strategies using appropriate frameworks like JUnit/NUnit/Selenium as appropriate. * Process Improvements / Delivery Excellence. * • Identify avenues to improve project delivery parameters (eg productivity, efficiency, process, security etc) by leveraging tools, automation etc. * • Understand various technical tools used in the project (third party as well as homegrown) to improve efficiency , productivity. * • Provide support for project estimations in terms of review and validation for projects of lower complexity based on analyzing business requirements (eg component level estimation). * • Articulate estimation methodology, module level estimations for more standard projects with focus on effort estimation alone. * Project estimation. * • Provide support for project estimations in terms of review and validation for projects of lower complexity based on analyzing business requirements (eg component level estimation). * • Articulate estimation methodology, module level estimations for more standard projects with focus on effort estimation alone. * Audit. * • Conduct cross project technical audits and reviews, as required to check adherence to architecture, design and coding best practices. * • Perform codenizant audits for other projects as appropriate to ensure Codenizant principles are implemented. * Proposal Development. * • Contribute to proposal development [of small to medium size projects from technology/architecture perspective]. Cognizant Technology Solutions Atlanta GA

ETL Tester

Cognizant Technology Solutions