Etl Developer

4 weeks ago


Noida, Uttar Pradesh, 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 xc2 xb7 To interact with the Business onsite offshore counterparts to understand business requirement and transforming business rule into technical specifications xc2 xb7 Responsible for all activities related to the development implementation of ETL processes for large scale data warehouses using Informatica Power Center 10 5 xc2 xb7 Perform root cause analysis of job failures and propose solutions to perform complex troubleshooting xc2 xb7 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 xc2 xb7 Involved in performance tuning of mappings and sql queries for better performance and efficiency xc2 xb7 Monitoring interfaces and informatica sessions resolving on-going maintenance issues and bug fixes xc2 xb7 Documentation for all the activities involved in different phases of development cycle xc2 xb7 Should be able to identify the areas of improvement and re-engineering scope xc2 xb7 Participating in discussions with cross commits xc2 xb7 Helping other team members to resolve their technical issues xc2 xb7 Mentoring the interns and new joiners xc2 xb7 Monitor and report issues and work with the required team vendor for quick resolution xc2 xb7 Should be open to learn new technologies tools Required Qualifications xc2 xb7 Bachelors degree in computer science Engineering or related field or equivalent work experience xc2 xb7 2- 4 years of relevant experience xc2 xb7 Strong Informatica IICS and ETL fundamentals xc2 xb7 Should be experienced in Data Warehouse Data mart and OLAP implementations requirements gathering data modeling Effort Estimation ETL Design development System testing Implementation xc2 xb7 Hands-on experience on a job scheduling tool - preferably with TWS or Tidal xc2 xb7 Hands-on experience on Power Exchange to create data map from Mainframe copybook xc2 xb7 Working Experience of Informatica Intelligent Cloud Services IICS and Python xc2 xb7 Basic knowledge of AWS services S3 Lambda EMR xc2 xb7 Basic Knowledge of Mainframe to validate the VSAM files created through ETL xc2 xb7 Knowledge of dev test prod environment code deployment processes xc2 xb7 Should be able to understand business requirements create technical specifications and design and implement the same using Integration technologies xc2 xb7 Should Understand and can interpret design and code UNIX shell scripts in bash ksh xc2 xb7 Conduct ETL workflow and mapping optimization review troubleshooting and debugging xc2 xb7 Understand and can interpret database access from Informatica and find optimization opportunities xc2 xb7 Understand and can interpret scheduling of ETL based batch xc2 xb7 Provides solutions to the critical issues in ETL Informatica power center and IICS xc2 xb7 Provides software support for ETL Informatica power center and IICS xc2 xb7 Provides technical assistance for incoming queries and issues related to the software products xc2 xb7 Maintains operational day-to-day IT functions of software products xc2 xb7 Performs root cause analysis to determine nature of software environment issues as they arise and provide the permanent fix for the issues xc2 xb7 Experience with multi-vendor environment and Ability to work in a high-pressured tight deadline environment xc2 xb7 Generate innovative ideas and apply them in implementing solutions xc2 xb7 Flexibility and adaptability towards changing organizational needs xc2 xb7 Good Communication skills xc2 xb7 Strong attention to detail and with ability to focus on quality and efficiency xc2 xb7 Ability to communicate and articulate technical information across various organizational levels xc2 xb7 Highly innovative problem solver with strong analytical and customer service abilities required xc2 xb7 High reasoning aptitude and ability to quickly understand complex operating environments xc2 xb7 Strong thought leadership and motivation with the ability to work independently xc2 xb7 Ability to work in a diverse multi-national and multi-vendor environment xc2 xb7 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 xc2 xb7 Experience working with Annuity and Insurance products and policy admin systems such as Oracle s OIPA xc2 xb7 Experience in Mainframe xc2 xb7 Proven ability to successfully translate client business needs into software designs xc2 xb7 Certification on ETL AWS is an added advantage xc2 xb7 Should be self-starter and team player in solving issues and mentoring other team members xc2 xb7 Automation and Continuous improvement support xc2 xb7 Experience in handling automated code deployments through GIT or other version control tools xc2 xb7 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 firms 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 Youll 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 timeTimings 2 00p-10 30p India Business Unit AWMPO AWMP S President s OfficeJob Family Group Technology


  • ETL Developer

    4 weeks ago


    Noida, Uttar Pradesh, India Zensar Technologies Full time

    Responsibilities :- Design, develop, and implement ETL jobs using industry-standard ETL tools (Informatica PowerCenter, Talend, SSIS).- Extract data from various sources such as databases (relational, NoSQL), flat files, APIs, and cloud platforms.- Transform data using techniques such as data cleansing, data enrichment, data aggregation, and data masking....

  • Senior ETL Developer

    3 weeks ago


    Noida, Uttar Pradesh, India DataFlow Group Full time

    Role Overview: We are looking for a highly skilled and experienced Senior ETL & Data Streaming Engineer with over 10 years of experience to play a pivotal role in designing, developing, and maintaining our robust data pipelines. The ideal candidate will have deep expertise in both batch ETL processes and real-time data streaming technologies, coupled with...

  • senior etl developer

    4 weeks ago


    Noida, Uttar Pradesh, India Siera IT Services Private Limited Full time

    Job DescriptionJob Role:Sr. ETL DeveloperExperience:8+ yearsLocation: NoidaNotice Period: Immediate to 15DaysPosition Type: C2HJOB DESCRIPTION:Mandatory Skills:Oracle SQL , PL/SQL,Informatica, Linux Scripting , TidalDesired Skills:Python scriptingResponsible for workload prioritization and management of resources, both on service requests and small...

  • Senior ETL

    2 weeks ago


    Noida, Uttar Pradesh, India Dataflow Group Full time

    About the Organisation : DataFlow Group is a pioneering global provider of specialized Primary Source Verification (PSV) solutions, and background screening and immigration compliance services that assist public and private organizations in mitigating risks to make informed, cost-effective decisions regarding their Applicants and Registrants.About the Role :...

  • ETL Developer

    5 days ago


    Noida, Uttar Pradesh, India beBeeEtl Full time ₹ 20,00,000 - ₹ 25,00,000

    Job Title: ETL Developer - Informatica IDMCWe are seeking an experienced ETL Developer to join our team. As a key member of our data integration team, you will be responsible for designing, developing, and maintaining robust ETL pipelines using Informatica IDMC (IICS).You will collaborate with data architects, analysts, and business stakeholders to gather...

  • ETL Tester

    3 weeks ago


    Noida, Uttar Pradesh, India Strategic Talent Partner Full time

    Role : QA Automation EngineerJob Description : As a QA Automation Engineer specializing in Data Warehousing, you will play a critical role in ensuring that our data solutions are of the highest quality. You will work closely with data engineers and analysts to develop, implement, and maintain automated testing frameworks for data validation, ETL processes,...


  • Noida, Uttar Pradesh, India beBeeInformatica Full time ₹ 15,00,000 - ₹ 25,00,000

    Job Overview:We are seeking a highly skilled Informatica Support Senior Developer to join our team.This role will be responsible for providing expert-level support and guidance on the design, development, implementation, administration, and troubleshooting of ETL processes using Informatica PowerCenter/IDQ/MDM/IICS tools.


  • Noida, Uttar Pradesh, India beBeeDataStage Full time

    Job Title: Datastage DeveloperAbout the Role:As a seasoned Datastage Developer, you will play a pivotal role in designing, developing, testing, and deploying complex ETL processes using IBM Datastage. Your expertise will be instrumental in creating efficient data pipelines for extracting, transforming, and loading data from various sources into data...


  • Noida, Uttar Pradesh, India beBeeDataSpecialist Full time ₹ 15,00,000 - ₹ 25,00,000

    Overview:As a Data Warehousing Specialist, you will play a critical role in ensuring that data solutions are of the highest quality.Develop and implement automated testing frameworks for data validation, ETL processes, data quality, and integration.Work closely with data engineers and analysts to develop and maintain high-quality data products.Benefits:A...


  • Noida, Uttar Pradesh, India beBeeProductionSupport Full time ₹ 12,00,000 - ₹ 25,00,000

    Production Support ConsultantWe are seeking a seasoned Production Support consultant with extensive experience in ETL production support. The ideal candidate will have a strong background in production support and be proficient in writing and debugging shell scripts, Informatica PowerCenter, Unix/Linux, SQL, and PL/SQL.Key Responsibilities:Provide production...