17 Oct
TATA AIA LIFE INSURANCE
Ghaziabad
APosition Overview
Position Title
ETL Developer
Department
Technology
Level/ Band
Assistant Manager
Role Summary :
We are seeking a skilled ETL (Extract, Transform, Load) Developer with 4-7 years of hands-on experience to join our dynamic team. As an ETL Developer, you will be responsible for designing, developing, and implementing robust ETL processes to extract, transform, and load data from our data source to MS Azure data warehouse.
1. Data Integration: Design and implement efficient data integration solutions, ensuring seamless and accurate data flow from source systems to the data warehouse.
2. ETL Development: Develop, optimize, and maintain ETL processes using industry best practices and standards,
focusing on performance, scalability, and data quality.
3. Data Modeling: Collaborate with data architects to design and implement data models that support ETL processes and facilitate effective data retrieval.
4. Performance Tuning : Identify and address performance bottlenecks in ETL processes, optimizing data transformation and loading for improved efficiency.
5. Quality Assurance : Implement data validation and reconciliation procedures to ensure the accuracy and completeness of transformed data.
6. Documentation : Create comprehensive documentation for ETL processes, ensuring knowledge transfer and ease of maintenance for future enhancements.
7. Collaboration : Work closely with cross-functional teams, including data analysts, business intelligence developers, and business stakeholders, to understand data requirements and deliver effective solutions.
8. Troubleshooting : Diagnose and resolve issues related to data extraction, transformation, and loading,
providing timely support to ensure minimal disruption to business operations.
BOrganizational Relationships
Reports to
AVP
Supervises
N/A
CJob Dimensions
Geographic Area Covered
India
Internal Stakeholders
AVP, VP
External Stakeholders
N/A
DKey Result Areas
·IFRS 17 solution implementation is preferred.
·Acting as a mentor to team members.
·Ensuring all technology practices adhere to regulatory and compliance standards.
Minimum Requirements :
·4 – 6 years Technology Delivery Experience with bachelor’s degree or master's degree in computer science, information systems, engineering, related field or equivalent work experience.
·Advanced technological skillset and a demonstrated history with technology like ETL,
Azure DATA Lake, Oracle pl Sql, .net, SQL Server etc.
·Sound knowledge pertaining to Infrastructure on Cloud.
·Exceptional team management skills.
·Excellent verbal and written communication.
·Ability to delegate efficiently.
·A deep passion for innovation and improving organization performance through the
·application of immerging technologies and practices.
·A strong desire to continually learn about new technologies.
·Results oriented and metrics driven operational leader.
·Work well under minimal supervision.
ECompetencies (Please copy paste from Competency Dictionary)
Competency For
Proficiency Scale
Proficiency Scale Description
Drive for Results
Exhibits passion,
drive and perseverance to plan tasks and deliver results with consistency, as per the required business goals by overcoming challenges and holding self and others accountable.
2
oDemonstrates consistency in performance and stays focused on the end result.
oIs aware of the business goals to be achieved and takes accountability to deliver results as per set plans and deadlines.
oFinds solutions to address problem at hand in the face of constraints
Change Management
Can develop strategies for change, aligning changes with the organization’s strategic direction, objectives and expectations. Questions conventional approaches and fosters an environment of innovation and change, implements new or cutting-edge programs/processes
for competitive advantage.
Capitalizes on opportunities and manages risks. Rapidly adapts to new information, changing conditions, processes or unexpected obstacles. Deals effectively with pressure.
2
Questions traditional methods to initiate new perspectives.
oEvaluates ideas for practicality and feasibility and thinks through an innovative conclusion.
oDemonstrates good understanding of how changes might impact one’s own area of work.
oCan bring fresh perspectives, new insights in own area of work.
oEmbraces change initiatives positively.
oMaintains motivation and effective performance of self and team in the
face of constant change and significant obstacles
Technology, Digital and Analytics
Ability to choose, develop,
adopt and apply technological solutions and explore creative usage of technical resources to sustainably elevate and advance business outcomes as well as demonstrate agility to consistently deliver required business goals by overcoming technological challenges and adapting quickly in a changing technological environment. Ability to accelerate business with data & analytics and drive analytics transformations
2
oDemonstrates a good understanding of the technological advancements
and works with peers or colleagues to test the viability of a new technology tool before applying it in one’s area of work by ensuring the outcome is
error-free.
oAbility to alter conventional processes and highlight challenges that can be
enabled with technology.
oStays calm in ambiguous or demanding technological changes in one’s area of work.
oIdentifies critical connections and patterns in information/data and is able to analyze verbal and numerical data for functional excellence.
oRecognizes causes and consequences of data related actions that are not readily apparent
GSkills Required
Technical
§ETL
Behavioral
Good Communication, Committed, Good Team Player
Essential
Desired
Interpersonal skills
Yes
Communication skills
Yes
Creative thinking skills
Yes
Supervising/Leadership skills
Yes
Teamwork Skills
Yes
Influencing skills
Yes
Relationship Building skills
Yes
Decision making skills
Yes
HIncumbent Characteristics
Essential
Desired
Qualification
Bachelor’s Degree
Experience
4 - 7 Years- Assistant Manage
▶️ Executive Relationship Manager - LOY
🖊️ TATA AIA LIFE INSURANCE
📍 Ghaziabad