Lead ETL Developer

Loc - Mumbai / Hyd / Bangalore

Demonstrates expert abilities and extensive Application Managed Service projects and  solutioning the Informatica ETL Tool integration with Guidewire Suite of applications on premises and SaaS, with proven success executing and leading all aspects of complex engagements achieving on-time and on-budget delivery, as well as the following:

6+ years of experience as technical lead for Informatica and ETL tools
Strong understanding of data warehouse concepts and dimensional data modeling
Expertise with SQL queries, analytical services, reporting services
Experience with one or more SDLC methodologies
Expertise related to metadata management, data modeling, data model rationalization, and database products
Experience with data scripting and programming
Understands context of their project within the larger portfolio
Demonstrated a strong attention to detail
Possesses strong analytical skills
Demonstrated a strong sense of ownership and commitment to program goals
Strong verbal and written communication skills
Identifies and implements operational database requirements and proposed enhancements in support of requested application development or business functionality
Develops and translates business requirements into detailed data designs
Maps data between systems (in conjunction with Business Analysts)
Assists engineering and development teams as application data expert from physical data models to production implementations
Identifies entities, attributes, and referential relationships for data models using a robust enterprise information engineering approach
Creates tables, indexes, constants, and assist programmers with SQL, tuning and reviews
Participates in data analysis, archiving, database design, and development activities for migration of existing data as needed
Develops ETL interfaces from source databases and systems to the data warehouse
Works closely with application development teams to ensure quality interaction with the database

Job Functions:

(1) To be responsible for providing technical guidance or solutions

(2) To develop and guide the team members in enhancing their technical capabilities and increasing productivity

(3) To ensure process compliance in the assigned module, and participate in technical discussions or review.

(4) To prepare and submit status reports for minimizing exposure and risks on the project or closure of escalations.

Technologies

• ETL tools (Informatica, Snowflake SSIS, Talend, etc.) and its Integration with Guidewire suite of applications and Conversion ETL tools
• SQL competence (query performance tuning, index management, etc.) and a grasp of database structure are required.
• Understanding of data modeling concepts.

Knowledge of different SQL/NoSQL data storage techniques