Senior ETL Developer

About Our Company

Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 20 years. We are part of Ameriprise Financial Inc., a US financial planning company headquartered in Minneapolis with a global presence and diversified financial services leader with more than $1.5 trillion in assets under management, administration and advisement as of year-end 2024. The firm’s focus areas include Asset Management and Advice, Retirement Planning and Insurance Protection.

Be part of an inclusive, collaborative culture that rewards you for your contributions, and work with other talented individuals who share your passion for doing great work. You’ll also have plenty of opportunities to make your mark at the office and a difference in your community. So, if you're talented, driven and want to work for a strong, ethical company that cares, take the next step and create a career at Ameriprise India LLP.

Job Description

Responsible for Designing, Coding, Testing, Implementing, Maintaining and Supporting ETL applications that is delivered within scope, with high quality, on time and within budget.
Work closely with Business partners, & Technology team members to understand business requirements, perform analysis and design of quality technical solutions that comply with the organization's architectural standards. Provide technical guidance to the development team through the full software life cycle.

Key Responsibilities

• Develop solution in highly demanding environment and provide hands on guidance to other team members.
• Implement an Informatica based ETL solution fulfilling stringent performance requirements.
• Work closely with customers, business analysts and technology & project team to understand business requirements, drive the analysis and design of quality technical solutions that are aligned with business and technology strategies and comply with the organization's architectural standards.
• Conduct impact assessment and determine size of effort based on requirements.
• Provide support to Project Manager in developing full SDLC project plans to implement ETL solution.
• Identify, recommend and implement ETL process and architecture improvements.
• Assist and verify design of solution and production of all design phase deliverables and documentation.
• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.
• Resolve difficult design and develop issues and performance Tuning of ETL code.
• Understand and follow-up through change management procedures to implement project deliverables.
• Coordinating with support groups such as DBA, Unix, Informatica admins to get the issues resolved in a quick turnaround time.

Working in Onshore/Offshore model.
 
Required Qualifications

• Bachelor’s degree in Computer Science, Engineering, or related field; or equivalent work experience.
• 4-7 years of relevant experience
• Expert with data warehousing standards, strategies and tools.
• Expert with SDLC processes.
• Experience in Informatica Power exchange for Mainframe, Salesforce and other new age
• data sources.
• Experience in Informatica Webservices, XML, Java Transformations etc.
• Strong knowledge of relational database preferably ORACLE and SQL Server.
• Good knowledge of UNIX/LINUX shell scripting.
• Strong SQL background.
• Strong problem-solving, multi-tasking and organizational skills.
• Good written and verbal communication skills.
• Experience working with US or other international customers.
• Proven ability to successfully translate client/business needs into software designs.
• Individual contributor with strong communication skills
• Proven ability to build relationship and collaborate with teams across organization
• Flexibility in timings for installs and secondary production support.

Preferred Qualifications

• AWS Cloud Knowledge, EC2, S3, AWS Glue ETL.
• TWS/Tidal scheduler hands-on experience.
• BFSI domain knowledge.
• Good to have experience in Informatica Cloud.

In-Office Collaboration
We are a client-centric, relationship-based business. Working together, in-person, is foundational to how we achieve results. By fostering a culture of face-to-face collaboration, idea sharing, productivity and personal connection, we deliver for our stakeholders — clients, advisors, employees and shareholders. Our employees work in the office at least three (3) days per week, with flexibility to work from home two (2) days per week. Some roles may require additional in-office time or different in-office expectations, and specific requirements will be discussed during the hiring process.
 

Full time(2:00p-10:30p)AWMPO AWMP&S President's OfficeTechnology

Ameriprise India LLP is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, genetic information, age, sexual orientation, gender identity, disability, military status, veteran status, marital status, pregnancy, family status or any other basis prohibited by law.

We are committed to fostering an inclusive and accessible recruitment process for individuals with disabilities. If you require a reasonable accommodation to participate in the application or interview process, speak to your recruiter to discuss how we can support you.