Senior Developer ETL

3 weeks ago

Noida, Uttar Pradesh, India Ameriprise Financial Full time
About the Role

We 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 transform them into technical specifications.

Key Responsibilities
  • Design and develop ETL processes for data warehousing using Informatica Power Center 10.5.
  • Develop and implement unit test cases and execute unit test plans.
  • Perform root cause analysis of job failures and propose solutions.
  • Involved in performance tuning of mappings and SQL queries for better performance and efficiency.
  • Monitor interfaces and Informatica sessions, resolving on-going maintenance issues and bug fixes.
  • Document all activities involved in different phases of the development cycle.
  • Identify areas of improvement and re-engineering scope.
  • Participate in discussions with cross-functional teams.
  • Help other team members to resolve their technical issues.
  • Mentor interns and new joiners.
  • Monitor and report issues and work with the required team/vendor for quick resolution.

Requirements
  • 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.
  • Experience 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.
  • Ability to understand business requirements, create technical specifications, and design and implement the same using integration technologies.
  • Ability to understand and interpret, design, and code UNIX shell scripts in bash/ksh.
  • Conduct ETL workflow and mapping optimization review, troubleshooting, and debugging.
  • Ability to understand and interpret database access from Informatica and find optimization opportunities.
  • Ability to understand and interpret scheduling of ETL based batch.
  • Provides solutions to 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 software products.
  • Maintains operational day-to-day IT functions of software products.
  • Performs root cause analysis to determine the 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 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.
  • 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.

  • 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

    4 weeks 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 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

    2 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

    23 hours 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...

  • 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...

  • AWS Data Engineer

    3 weeks ago

    Noida, Uttar Pradesh, India VIBRANT STAFFING SOLUTIONS PVT LTD Full time

    Job Description: We are seeking a skilled AWS Data Engineer to join our team at Vibrant Staffing Solutions Pvt Ltd. As an AWS Data Engineer, you will be responsible for designing and developing ETL pipelines using Airflow DAGs and Spark SQL.Responsibilities:Collaborate with business analysts to gather requirements for existing or new ETL pipelines.Design and...

  • Senior .NET Developer

    4 weeks ago

    Noida, Uttar Pradesh, India Altos Incorporated Full time

    About the Role:We are seeking a highly skilled and experienced Senior .NET Developer to join our dynamic development team at Altos Incorporated. The ideal candidate will have in-depth knowledge of .NET technologies, Rest API development, and modern software development practices, with hands-on experience in Azure, Angular, ETL processes, and DevOps...

  • Data Warehouse Developer

    4 weeks ago

    Noida, Uttar Pradesh, India Fujitsu Full time

    Data Warehouse DevelopmentAs a Senior Technical Consultant at Fujitsu, you will be responsible for designing and implementing data warehouses that can store and organize large volumes of data. This involves developing ETL/ELT processing, cleaning, and integrating large data sets from various sources. Ensuring data accuracy, completeness, and consistency is...

  • Senior Data Architect

    4 weeks ago

    Noida, Uttar Pradesh, India Fujitsu Full time

    Key ResponsibilitiesAs a Senior Technical Consultant at Fujitsu, you will be responsible for designing and developing data warehouses that can efficiently store and organize large volumes of data.Key SkillsDeveloping ETL/ELT processing, cleaning, and integrating large data sets from various sourcesEnsuring data accuracy, completeness, and...

  • Senior Oracle PL/SQL Developer

    3 weeks ago

    Noida, Uttar Pradesh, India TITAN CONSULTANCY Full time

    Job Title: Senior Oracle PL/SQL DeveloperLocation: Noida (WFO)Experience: 5+ yearsJob Summary: We are seeking a highly skilled Senior Oracle PL/SQL Developer to join our team at TITAN CONSULTANCY. The ideal candidate will have a minimum 5 years of experience developing applications using Oracle PL/SQL, working on Oracle Applications, SQL*Loader, Forms &...

  • Senior .NET Developer

    2 weeks ago

    Noida, Uttar Pradesh, India Altos Incorporated Full time

    About the JobAltos Incorporated is seeking an experienced Senior .NET Developer to join our dynamic development team. The ideal candidate will have in-depth knowledge of .NET technologies, Rest API development, and modern software development practices.Key Responsibilities- Design, develop, and maintain applications using .NET C#, ASP.NET Core, and Entity...

  • Senior Data Engineering Manager

    3 weeks ago

    Noida, Uttar Pradesh, India talentxo Full time

    Job Title: Senior Data Engineering ManagerAbout the Role:We are seeking an experienced Senior Data Engineering Manager to lead our data engineering team at Talentxo. As a key member of our organization, you will play a crucial role in designing and implementing scalable data integration solutions using various tools and technologies.Key Responsibilities:Lead...

  • Senior Data Analyst and Oracle Expert

    2 weeks ago

    Noida, Uttar Pradesh, India Fujitsu Full time

    Job DescriptionFujitsu seeks a highly skilled Senior Technical Consultant to develop data warehouses and perform ETL/ELT processing.Develop and maintain large-scale data warehouses using Oracle databasePerform data cleaning, integration, and transformation based on business rulesWork closely with PowerBI developers to understand data...

  • Data Tester

    2 weeks ago

    Greater Noida, Uttar Pradesh, India Coforge Full time

    Data Tester Role OverviewCoforge is seeking a skilled Data Tester with expertise in ETL and SQL to join our team. As a Data Tester, you will be responsible for testing and validating data flows, identifying data discrepancies, and developing data migration plans.Develop and execute data test plans to ensure data integrity and quality.Collaborate with...

  • Senior Data Engineer

    2 weeks ago

    Noida, Uttar Pradesh, India BirlaSoft Full time

    Key Responsibilities:As a Senior Data Engineer at BirlaSoft, you will be responsible for designing, developing, and maintaining large-scale data processing systems. You will work closely with the data science team to implement data pipelines, ETL processes, and data warehouses.Requirements:· 5+ years of experience in data engineering with strong SQL and...

  • Senior Data Engineer

    3 weeks ago

    Noida, Uttar Pradesh, India SDLC Corp Full time

    Job Title: Senior BI EngineerSDLC Corp is seeking a highly skilled Senior BI Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing and implementing data models to support business intelligence and reporting needs.Key Responsibilities:Design and implement data models to support business intelligence and...

  • Senior Snowflake Developer

    2 weeks ago

    Noida, Uttar Pradesh, India Media Full time

    About the RoleWe are seeking a highly skilled Senior Snowflake Developer to join our team at Monks. This is an exciting opportunity for a talented individual to play a key role in designing, developing, and supporting our Snowflake data warehouse solutions.Key ResponsibilitiesDesign and develop robust Snowflake data warehouse solutions that meet our business...