Job Description

LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 750 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries, LTIMindtree - a Larsen & Toubro Group company - combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale. For more information, please visit

Experience:

• 8+ years of experience with Oracle and SQL Server databases

• 8+ years of experience with Informatica Power Center.

• 8+ years software development experience in one or more of the following areas: ETL, BI and DW

• 8+ years of experience in DW Multi-Dimensional modeling.

• Understanding of the Project Delivery Framework and SDLC

• Understanding of Waterfall and Agile Project Management Methodology

• Strong analytical, communication and interpersonal skills.

• Excellent and proven collaboration skills

Responsibilities:

• Designs, develops, automates, and supports complex applications to extract, transform, and load data.

• Ensures data quality.

• Plans and conducts ETL unit and development tests; monitors result and takes corrective action.

• Work on basic and advanced transformations such as normalization, cleansing, aggregation, summarization, and integration.

• Performance Tuning of SQLs and handling huge volumes of data.

• Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds

• Build, maintain, and enhance all objects, packages/functions in PL/SQL to support the application process.

• Translates data access, transformation, and movement requirements into functional and mapping designs.

• Designs automation processes to control data access, transformation, and movement.

• Ensures source system data availability and update accessibility, data integrity, restart ability, and error handling.

• Participates in the overall development process via architecture guidance, design and code reviews, and estimation and planning assistance

• Performs other related duties as required. Knowledge, Skills, And Abilities

• Documents and troubleshoot problems and effectively communicate with business and technical team members at all levels.

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.

Larsen & Toubro Infotech