Senior Developer ETL

5 months ago

Noida, India Ameriprise Financial Full time
We are looking for a highly motivated and experienced individual with fresh ideas having passion & great acumen for ETL and data warehousing concepts. Strong working experience in Informatica Power Center, SQL and at least anyone scripting language is must. Good working knowledge in Agile model and should possess strong problem-solving skills and handling critical situations. Must have good knowledge of database systems and should be able to write basic and complex queries and have idea of advanced SQL concepts. Should be familiar with both Windows and UNIX environment.

Key Responsibilities

To interact with the Business, onsite/offshore counterparts to understand business requirement and transforming business rule into technical specifications. Responsible for all activities related to the development, implementation of ETL processes for large scale data warehouses using Informatica Power Center 10.5. Perform root cause analysis of job failures and propose solutions to perform complex troubleshooting. Involved in preparation of unit test cases and executing Unit test plan as well. Responsible for migration of informatica objects from one environment to another. Involved in performance tuning of mappings and sql queries for better performance and efficiency. Monitoring interfaces and informatica sessions, resolving on-going maintenance issues and bug fixes. Documentation for all the activities involved in different phases of development cycle. Should be able to identify the areas of improvement and re-engineering scope. Participating in discussions with cross commits. Helping other team members to resolve their technical issues. Mentoring the interns and new joiners. Monitor and report issues and work with the required team/vendor for quick resolution. Should be open to learn new technologies/tools.

Required Qualifications

Bachelor’s degree in computer science, Engineering, or related field; or equivalent work experience. 2 -7 years of relevant experience. Strong Informatica, IICS and ETL fundamentals. Should be experienced in Data Warehouse/Data mart, and OLAP implementations, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation. Hands-on experience on a job scheduling tool – preferably with TWS or Tidal. Hands-on experience on Power Exchange to create data map from Mainframe copybook. Working Experience of Informatica Intelligent Cloud Services (IICS) and Python. Basic knowledge of AWS services(S3, Lambda, EMR). Basic Knowledge of Mainframe to validate the VSAM files created through ETL. Knowledge of dev/test/prod environment code deployment processes. Should be able to understand business requirements, create technical specifications and design and implement the same using Integration technologies. Should Understand and can interpret, design and code UNIX shell scripts in bash / ksh. Conduct ETL workflow and mapping optimization review, troubleshooting and debugging. Understand and can interpret database access from Informatica and find optimization opportunities. Understand and can interpret scheduling of ETL based batch. Provides solutions to the critical issues in ETL (Informatica power center and IICS) Provides software support for ETL (Informatica power center and IICS) Provides technical assistance for incoming queries and issues related to the software products. Maintains operational day-to-day IT functions of software products. Performs root cause analysis to determine nature of software environment issues as they arise and provide the permanent fix for the issues. Experience with multi-vendor environment and Ability to work in a high-pressured, tight deadline environment. Generate innovative ideas and apply them in implementing solutions. Flexibility and adaptability towards changing organizational needs. Good Communication skills. Strong attention to detail and with ability to focus on quality and efficiency. Ability to communicate and articulate technical information across various organizational levels. Highly innovative problem solver with strong analytical and customer service abilities required. High reasoning aptitude and ability to quickly understand complex operating environments. Strong thought leadership and motivation with the ability to work independently. Ability to work in a diverse multi-national and multi-vendor environment. Ability to support working outside of normal business hours to provide after hour or "on-call" support when necessary to solve high profile incidents/problems.

Preferred Qualifications

Experience working with Annuity and Insurance products and policy admin systems such as Oracle's OIPA. Experience in Mainframe. Proven ability to successfully translate client/business needs into software designs. Certification on ETL/AWS is an added advantage. Should be self-starter and team player in solving issues and mentoring other team members. Automation and Continuous improvement support. Experience in handling automated code deployments through GIT or other version control tools. DevOps, CICD Pipeline knowledge.

About Our Company
Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 125 years. We are a U.S. based financial planning company headquartered in Minneapolis with a global presence. 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.

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, veteran status, marital status, family status or any other basis prohibited by law.

Full-Time/Part-Time

Full time

Timings

(2:00p-10:30p)

India Business Unit

AWMPO AWMP&S President's Office

Job Family Group

Technology

  • Senior ETL Developer

    1 month ago

    Noida, India Intellylabs technologies Full time

    Job Title: Senior/Lead ETL DeveloperCompany Overview:IntellyLabs Technologies is a leading IT software solution engineering company based in Noida. With a team of over 300 professionals, we leverage emerging technologies and best practices to deliver successful projects globally.Job Description:We are seeking an experienced Senior/Lead ETL Developer to join...

  • Senior ETL Developer

    4 weeks ago

    Noida, India Intellylabs technologies Full time

    Job SummaryIntellyLabs Technologies is seeking an experienced Senior ETL Developer to join our team in Noida. As a key member of our data integration team, you will design, develop, and maintain ETL processes to support our data integration needs.Key ResponsibilitiesDesign and develop ETL workflows and data integration solutions using Talend.Extract,...

  • Senior ETL Developer

    2 weeks ago

    Noida, Uttar Pradesh, India Ameriprise Financial Full time

    About the RoleAt Ameriprise India LLP, we are seeking a highly motivated and experienced Senior ETL Developer to join our team. This is a challenging and rewarding opportunity to work with a talented group of professionals on a wide range of projects.The ideal candidate will have a strong background in ETL development, data warehousing, and Informatica Power...

  • Senior Developer ETL

    4 weeks ago

    Noida, Uttar Pradesh, India Ameriprise Financial Full time

    About the RoleWe are seeking a highly motivated and experienced Senior Developer ETL to join our team. As a key member of our data warehousing team, you will be responsible for designing, developing, and implementing ETL processes for large-scale data warehouses using Informatica Power Center 10.5. Your strong working experience in Informatica Power Center,...

  • Senior Developer ETL

    1 month ago

    Noida, Uttar Pradesh, India Ameriprise Financial Full time

    About the Role We are seeking a highly motivated and experienced Senior Developer ETL to join our team. As a key member of our data warehousing team, you will be responsible for designing, developing, and implementing ETL processes for large-scale data warehouses using Informatica Power Center 10.5. Your strong working experience in Informatica Power Center,...

  • Senior Developer ETL

    3 weeks ago

    Noida, Uttar Pradesh, India Ameriprise Financial Full time

    About the Role:We're seeking a highly motivated and experienced individual to join our team as a Senior Developer ETL. As a key member of our ETL team, you will be responsible for all activities related to the development, implementation of ETL processes for large scale data warehouses using Informatica Power Center 10.5.Key Responsibilities:Interact with...

  • Senior/Lead ETL Developer

    2 months ago

    Noida, Ghaziabad, India Intellylabs technologies Full time

    Company Description : IntellyLabs Technologies is an award-winning IT Software Solution Engineering Company based in Noida. They offer end-to-end IT services across various technologies and industry verticals, transforming startups into successful enterprises. With a team of over 300 professionals, IntellyLabs leverages emerging technologies and best...

  • Senior/Lead ETL Developer

    2 months ago

    Noida, India Intellylabs technologies Full time

    Company Description : IntellyLabs Technologies is an award-winning IT Software Solution Engineering Company based in Noida. They offer end-to-end IT services across various technologies and industry verticals, transforming startups into successful enterprises. With a team of over 300 professionals, IntellyLabs leverages emerging technologies and best...

  • Senior Developer ETL

    4 weeks ago

    Noida, Uttar Pradesh, India Ameriprise Financial Full time

    About the RoleWe are seeking a highly motivated and experienced ETL Developer to join our team. As an ETL Developer, you will be responsible for designing, developing, and implementing ETL processes for large-scale data warehouses using Informatica Power Center 10.5. You will work closely with the business team to understand business requirements and...

  • Senior Java Developer

    4 weeks ago

    Noida, Uttar Pradesh, India NTT DATA Services Full time

    Job Title: Senior Java Developer - ETL Application MigrationWe are seeking a highly skilled Senior Java Developer to join our team in Noida, Uttar Pradesh, India. As a Senior Java Developer, you will be responsible for designing, implementing, and managing the product delivery, providing architectural direction, technical expertise, and thought...

  • Data ETL Developer

    3 weeks ago

    Noida, Uttar Pradesh, India Coforge Full time

    Job DescriptionData ETL Developer (ADF, Synapse, pySpark)4-7 years of working experience in ADF, Synapse, pySpark.

  • Senior/Lead Data Integration Developer

    5 days ago

    Noida, Uttar Pradesh, India Intellylabs technologies Full time

    Job Title: Senior/Lead Data Integration DeveloperAre you an experienced ETL Developer looking to join a dynamic team? We are seeking a Senior/Lead Data Integration Developer to design, develop, and maintain ETL processes at IntellyLabs Technologies.Key Responsibilities:- Design, develop, and implement ETL workflows and data integration solutions using...

  • Appzlogic Mobility

    2 months ago

    noida, Ghaziabad, India Appzlogic Mobility solutions Pvt. Ltd. ,Noida Full time

    Mandatory Skills : IICS, Powercenter, PL/SQLCloud : Azure (Azure Data Factory, Azure Data Lake) or AWS (Glue)- 7+ yrs of experience as Data Engineer, ETL Developer, proficient in Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS), and PL/SQL. Who can design, develop, and maintain ETL processes to support data integration and business...

  • Appzlogic Mobility

    2 months ago

    Noida, India Appzlogic Mobility solutions Pvt. Ltd. ,Noida Full time

    Mandatory Skills : IICS, Powercenter, PL/SQLCloud : Azure (Azure Data Factory, Azure Data Lake) or AWS (Glue)- 7+ yrs of experience as Data Engineer, ETL Developer, proficient in Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS), and PL/SQL. Who can design, develop, and maintain ETL processes to support data integration and business...

  • Senior Data Analyst

    1 month ago

    noida, India GEDU Services Full time

    Position : Senior Data AnalystJob Role : Power BI Developer Location : NoidaWork Mode : WFONumber of Days : 5daysPosition Overview :The Power BI Developer/Analyst is responsible for designing, developing, and deploying business intelligence reports using Microsoft's Power BI. This role involves working closely with stakeholders to gather requirements, create...

  • Senior BI Engineer

    1 month ago

    Noida, India SDLC Corp Full time

    SDLC Corp, Your Technology Partner, has been in operation since 2015 with a global presence across continents like the US, UK, Dubai, India, Germany, and Australia. Specializing in Software Development as a Service (SDaaS), we deliver innovative solutions tailored to unique needs using cutting-edge technologies. Role Description :- Design and implement data...

  • Axtria ETL Developer/Lead

    1 month ago

    Noida, India Axtria India Pvt. Ltd. Full time

    Job Description**About the Role**We are seeking a highly skilled ETL Developer/Lead to join our team at Axtria India Pvt. Ltd. The ideal candidate will have a strong background in data integration, ETL tools, and data warehousing, with a focus on the life sciences industry.Key Responsibilities:Design and implement effective database solutions and data models...

  • ETL Tester

    1 month ago

    Pune/Noida/Gurgaon/Gurugram, India Spectral Consultants Full time

    ETL Tester Job DescriptionRole Summary: We are seeking an experienced ETL Tester to join our team at Spectral Consultants. The successful candidate will be responsible for testing ETL processes to ensure data quality and integrity.Key Responsibilities:Develop and execute test plans to validate ETL processesCollaborate with development teams to identify and...

  • Process Mining- Etl

    5 months ago

    Noida, India Covi-Sense Full time

    Job role : Process Mining (ETL developer) Exp : 5+ Years Skills: Experience with ETL / ETL and BI tools (e.g., tableau, Informatica,SSIS ,Power BI ,Talend etc.) - Knowledge of process improvement techniques / tools and Process Mining / Analytics. - Basic knowledge of pythonScripting, should be knowing about (numpy, pandas, seaborn, matplotlib, sklearnetc) -...

  • Senior Oracle Applications Developer

    2 weeks ago

    Noida, Uttar Pradesh, India TITAN CONSULTANCY Full time

    Job Title: Senior Oracle Applications DeveloperJob Summary: We are seeking a highly skilled Senior Oracle Applications Developer to join our team at TITAN CONSULTANCY. As a Senior Oracle Applications Developer, you will be responsible for designing, developing, and implementing Oracle-based solutions for our clients.Key Responsibilities:Developing Oracle...