Senior Lead Etl Developer

Our story
At Alight, we believe a company's success starts with its people.
It's why we're so driven to connect passion with purpose.

Our team's expertise in human insights and cloud technology, allows companies and employees around the world to transform and thrive.

With a competitive total rewards package, continuing education and training and tremendous potential with a growing global organization, Alight is the perfect place to put your passion to work.

Job Summary:

The ETL (Extract Transform Load) Senior Application Developer Technical Lead role is responsible for leading the development of the technical detailed design (Low-Level Design) and is responsible for overall quality and timeliness of the deliverables.
The responsibilities of this role include applying the established methodology, processes, and procedures to the development work.

The Senior Application Developer Technical Lead role is responsible for technical project management of the assigned work and may oversee and review the work of others.
The role also contributes to improvising the existing processes and implementing new methods and the developing of best practices.

Key Responsibility Areas:
Requirements Elicitation, Understanding, Analysis, & Management
• Understand the project's Vision and requirements, and contribute to the creation of the supplemental requirements, building the low-level technical specifications for a particular platform and/or service solution.
• Review provided requirements, perform gap and/or impact analysis, and establish quality targets.
Project Planning, Tracking, & Reporting
• Estimate the tasks and resources required to design, build, and test the code for smaller projects or pieces of a project.
• Provide inputs in creating the detailed schedule for the project.
• Support the team in project planning activities, in evaluating risks, and shuffle priorities based on unresolved issues.
• During development and testing, ensure that assigned parts of the project/modules are on track with respect to schedules and quality.
• Note scope changes and work with team to shuffle priorities accordingly and/or make appropriate business decisions.
• Communicate regularly with the team about development changes, scheduling, and status.
• Communicate team schedule and status information to the team.
• Participate in project review meetings.
Design
• Provide inputs to the creation of High-Level Design (HLD)..
• Create the Low-Level Design (LLD)/detailed design for the project with possible alternate solutions.
Ensure that LLD design meets business requirements.
• Review and validate the LLD of individual modules created by other analysts before the start of code development.
• Submit the LLD design for review.
• Fix the detailed (LLD) design for the project for the comments received and submit the design to begin code development.
Development & Support
• Build the code of high-priority and complex systems according to the functional specifications, detailed design, maintainability, and coding and efficiency standards.
• Use code management processes and tools to avoid versioning problems.
• Ensure that the code does not affect the functioning of any external or internal systems.
Perform peer reviews of code to ensure it meets coding and efficiency standards.
• Act as the primary reviewer to review the application code created by software engineers to ensure compliance to defined standards.
Recommend changes to the code as required.
• Utilize the ETL application to analyze data, necessary to resolve issues uncovered and related to source data, ensuring technical specifications are thorough.
• Performs ETL tuning and SQL tuning.
Optimizes Informatica code performance and processing methods.
• Prepare and perform the deployment of code between environments.
• Monitor outstanding programming issues until they are resolved.
Testing & Debugging
• Attend the Test Design walkthroughs to help verify that the plans and conditions will test all functions and features effectively.
• Perform impact analysis for assigned issues for self and team.
• Actively assist with project- and code-level problem solving, such as suggesting paths to explore when testing engineers or software engineers encounter a debugging problem, and escalate urgent issues.
Documentation
• Review technical documentation for the code for accuracy, completeness, and usability.
• Document and maintain the reviews conducted and the unit test results.
Process Management
• Adhere to the project process.
• Participate in root cause analysis.
• Collect and Report Metrics for the project (e.g.
Utilization, Schedule Adherence, SLA Adherence etc).
• Identify root causes of delivery issues (e.g., system edits, manual processes, patterns in workflows, repeat calls etc.)
• Analyze the ongoing process to identify process improvement opportunities.
• Recommend process improvements and identify opportunities to define/follow standard operating procedures.
Coaching
• Act as a technical subject matter expert for the internal team on areas such as system functionality and approach including solving systems operations issues, performance initiatives.
Leverage existing knowledge and expertise in multiple ways.
• Build team skills using formal and/or informal training sessions.
• Coach team members technically about the system and existing workflow and processes to quickly bring them up to speed.
• Create and maintain knowledge repositories for lessons learnt and developments in the respective domains.
• Act as an expert resource to internal teams/client teams on system functionality and approach, including solving systems operations issues, and performance initiatives.
Position Requirements-Formal Education & Certification:• Bachelor's degree (with preferred concentrations in Computer Science, MIS, Engineering) or equivalent work experience.
Masters Degree in related area preferred.
• Computer application certifications, as applicable.

Knowledge & Experience:
• 6+ years of data integration, data warehousing, or data conversion experience.
• 4+ years of SQL writing and optimization experience.
4+ years of Informatica PowerCenter experience.
• 2+ years working with Microsoft SQL Server Management Studio.
• Experience with XML file data integration.
• Experience with UNIX shell scripting.
• Experience with Microsoft Dynamics or other CRM system preferred.
• Strong understanding of using ETL tools to integrate internal and third party systems.
Work hours
• 1 PM-10 PM (IST)
Join our team.
Because transformation takes a workforce.
Learn more at

Our commitment to Diversity and Inclusion
Alight believes diversity should be visible, valued, and sustained throughout the organization.

And we're committed to enabling an inclusive culture of belonging that engages all colleagues and grows the diversity of our talent to proudly represent the clients and communities we serve.

As an affirmative action employer, we adhere to the principles of equal employment opportunity in the workplace as defined in our diversity policy statement.
Diversity Policy Statement

Alight does not discriminate against anyone based on sex, gender, race, color, religion, creed, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, marital or domestic partner status, citizenship, military or veteran status, sexual orientation, gender, gender identity or expression, genetic information, or any other legally protected characteristics or conduct covered by federal, state, or local law.

In addition, we take affirmative action to employ and advance in employment qualified minorities, women, disabled persons, disabled veterans, and other covered veterans.

Alight provides reasonable accommodations to the known limitations of otherwise qualified employees and applicants for employment with disabilities and sincerely held religious beliefs, practices, and observances, unless doing so would result in undue hardship.
Applicants for employment may request a reasonable accommodation/modification by contacting his/her recruiter.

Authorization to work in the Employing Country

Applicants for employment in the country in which they are applying (Employing Country) must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the Employing Country and with Alight.

Note, this job description does not restrict management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units