ETL Testing

Job description

Position Description:

At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve. At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com.

This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please.

Job Title: ETL Tester
Position: Data Analyst/ETL Tester
Experience:3+Years
Category: IT Infrastructure
Main location: Gurgaon
Position ID: J1024-2111

Your future duties and responsibilities:

JD:
3+ Years experience in Data Testing

• Tester to validate data loads from source system in SQL server databases or flat files to target Snowflake tables, and vice versa. The individual should understand data structures and relationships and can interpret and validate data integrity
• Skills required to perform role (sql, aws, etc)
• Writing complex SQL queries to verify data
• Understand database schemas ad table relationships
• Understand the load processes such as Informatica and their potential issues
• Experience with snowflake and cloud technology is a bonus
• Good Communication skills
• Work as a team player / Strong Collaboration

• Reviews business requirements and provides comments on accuracy and completeness.
• Contributes to the identification and assessment of risks and exposures.
• Attends design reviews and understands application and system designs at a basic level.
• Develops and maintains test plans (including identifying test situations/scenarios) for less complex functions.
• May be responsible for conducting a test plan review and acquiring test plan signoff.
• Designs and creates test case documentation including test situations, data setup, execution steps and expected results.
• Interacts with business analysts/developers and other project team members while developing expected results and verifying results.
• Executes test cases for various types of testing including function, conversion, integration, intersystem, platform, parallel, stress, or regression.
• Logs all defects in Quality Center and manages defects until they are closed, approved, or deferred.
• Provides regular status updates to Test Lead or Project Manager including any known issues or test concerns.
• Provides input or completes Test Report.
• Maintains clear communication with Test Lead.
• Able to work flexible hours and weekends as required.
• Participates in lessons learned.

Required qualifications to be successful in this role:

• 3+ years of Overall IT experience.
• College graduate degree from reputed organization
• Good communication skills.
• Team Player.
• Good Reasoning and analytical skills
• Exposure to Customer Communication

Skills:

·  Selenium
·  SQL

What you can expect from us:

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our team—one of the largest IT and business consulting services firms in the world.