Lead Consultant – SQL_DB_Informatica

Lead Consultant – SQL_DB_Informatica

Genpact
5-8 years
Not Specified

Job Description


Lead Consultant &ndash SQL_DB_Informatica
:Operations
Location:Noida, India
With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world&rsquos biggest brands&mdashand we have fun doing it. Now, we&rsquore calling all you rule-breakers and risk-takers who see the world differently, and are bold enough to reinvent it. Come, transform with us.
Are you the one we are looking for
Inviting applications for the role ofLead Consultant &ndash SQL_DB_Informatica
In this role, you will be responsible for crafting clean, functional code that flawlessly suits the needs of the company. Your main focus will be coding and ensuring high performance and responsiveness to requests. To support Engineer using Agile Methodology and should have an end to end understanding of business use cases, to transform them into an effective and strategic solution. Work with business people to have a real time problem and, craft the solution which really fits into client needs.
Responsibilities

  • Engage with Client to participate in requirement gathering, Status update on work, UAT and be the key partner in the overall engagement

  • Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications

  • Crafts ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter

  • Write complex SQL queries with performance tuning and optimization, including creating views, stored procedures, triggers

  • Identifies data sources and works with source system team and data analyst to define data extraction methodologies.

  • Can work independently, lead and mentor the team


Qualifications we seek in you
Minimum qualifications

  • BE/B Tech

  • Excellent written and verbal communication skills


Preferred qualifications

  • 5+ years relational database experience (preferably SQL server) with strong database fundamentals(partitioning/indexing/designing), PL/SQL concepts & strong SQL skill

  • Strong SQL skills and database programming skills including creating views, stored procedures, triggers, implementing referential integrity, as well as designing and coding for performance.

  • Worked with large data sets and was proficient using Analytical functions

  • Hands-on experience working with Informatica power center.

  • Should have good knowledge on performance tuning in Informatica

  • Experience in shell scripting


Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws.Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, client focus, and innovation. For more information, visit www.genpact.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube.

About Genpact

Job Source : genpact.taleo.net

Similar Jobs

Career Advice to Find Better