ETL Developer

7 days ago

bangalore, India Sphere IT Full time
Job Purpose
The Information Management stream delivers outcomes to help different parts of the bank gain meaningful insights from their Data Assets. Our core function spans multiple BMW, Data Warehouses, Hadoop, Business Intelligence and Analytics Cluster within Information Management.
Responsible for ETL program design, coding, unit testing and production support of ETL programs primarily using informatica Power Center. Monitor all alerts and Report any issue that may significantly impact the business. Create/develop/utilize application monitoring solutions to enhance application availability and performance in production. Optimizing/ tuning of the complex PLSQL/SQL queries in production. Developing ETL programs to implement or modify the business requirements.
3.
Key Responsibilities:
Executing and monitoring production data and data exchange related processes, timely and conscientiously
Executes defined standard operating procedures (SOPs) as per defined schedule viz. Daily, Weekly, Monthly, Quarterly and Yearly
Monitoring day-to-day jobs running in production and ensure ETL process run successfully and responding to any production-related incidents or outages
Building ETL workflows, jobs or scripts or custom scripting languages to automate the data integration process.
Shifts focus between clients and/or processes throughout the day to meet production needs.
Assists in outage resolution, validation after weekend patching and rollover activities
Initiates troubleshooting and/or appropriate notification of issues timely.
Investigating and diagnosing ETL job failures, data inconsistencies, or other technical problems to identify root causes and implement appropriate solutions.
Monitoring ETL jobs and workflows proactively to identify potential issues or performance bottlenecks. Setting up alerts to notify stakeholders of any deviations or errors.
Loading the transformed data into the target data warehouse, data marts, or other destination systems following the defined data models.
Maintaining metadata documentation for ETL processes, including data lineage, mappings, and transformations.
Monitoring ETL jobs and system performance to identify and address any issues promptly. This involves troubleshooting and resolving problems that may arise during data integration.
Working on the tickets raised by the downstream users and resolve the tickets within the SLA.
Fixing of issues in production and deploying the changes in production with proper test documents and CR’s.
5.
Knowledge, Skills and Experience
Core Skills:
5-8 Years of Total Experience in Data Warehouse, Informatica, Oracle PL/SQL, Microsoft SQL Server, Unix, Hadoop, Hive, Python, Spark
Strong in writing & tuning the ETL Jobs, DB Programs and Queries, Python, Spark, Hive, Cloudera
Sound in Data Management Fundamentals and Data Architect, Modelling, Governance.
Strong Domain Knowledge in Banking/Finance area like understanding of the various processes, products, and services within the banking industry, core functions, regulations, and operational aspects of banking institutions.
Hands on knowledge in Various Schedulers like autosys, automic and UC4.
Hands on knowledge in Hadoop and cloud ecosystem and ETL jobs migration
Willingness to work in a 24x7 shift model
Additional Skills Desired:
Good Communication Skills
Good Team Player
Strong Analytical Thinking
Ability to handle stakeholders.
Confident in decision making and the ability to explain processes or choices as needed.
Ability to multitask on multiple projects in various phases.
Project Methodology Knowledge
Computer Science degree or equivalent

  • ETL Developer

    7 days ago

    bangalore, India Astria Digital Full time

    We are hiring an ETL Developer at Astria Digital with a strong background in Data Warehousing and ETL process using Informatica .The ETL Developer will be responsible for the day-to-day tasks associated with data extraction, transformation, and loading (ETL). They will utilize ETL tools and analytical skills to integrate data and create data models. The role...

  • ETL Developer

    3 days ago

    Bangalore, India Astria Digital Full time

    We are hiring an ETL Developer at Astria Digital with a strong background in Data Warehousing and ETL process using Informatica .The ETL Developer will be responsible for the day-to-day tasks associated with data extraction, transformation, and loading (ETL). They will utilize ETL tools and analytical skills to integrate data and create data models. The...

  • ETL Developer

    1 week ago

    Bangalore, India Gainwell Technologies LLC Full time

    Summary As a ETL Developer at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest...

  • Senior ETL Developer

    7 days ago

    bangalore, India Worldpanel by Kantar Full time

    About usKantar is the world’s leading data, insights and consulting company. We understand more about how people think, feel, shop, share, vote and view than anyone else. Combining our expertise in human understanding with advanced technologies. Kantar’s 25,000 people based in more than 100 countries help the world’s leading organisations succeed and...

  • ETL Datastage Developer

    7 days ago

    bangalore, India Birlasoft Full time

    1. About the Job - The candidate should require mandatory ETL DataStage Experience.2. Job Title - ETL DataStage Developer3. Location Bangalore, Hyderabad, Noida, Pune, Chennai, Mumbai4. Educational Background - UG. B. Tech /B. E in any specialization & PG. MCA/MSC in Computers5. Key Responsibilities -5-10 years’ experience in ETL...

  • ETL Developer

    1 week ago

    Bangalore Urban, India Sphere IT Full time

    Job PurposeThe Information Management stream delivers outcomes to help different parts of the bank gain meaningful insights from their Data Assets. Our core function spans multiple BMW, Data Warehouses, Hadoop, Business Intelligence and Analytics Cluster within Information Management.Responsible for ETL program design, coding, unit testing and production...

  • ETL Developer

    7 days ago

    Bangalore Urban, India Sphere IT Full time

    Job Purpose The Information Management stream delivers outcomes to help different parts of the bank gain meaningful insights from their Data Assets. Our core function spans multiple BMW, Data Warehouses, Hadoop, Business Intelligence and Analytics Cluster within Information Management. Responsible for ETL program design, coding, unit testing and production...

  • ETL Developer

    2 days ago

    Bangalore, India BT Group Full time

    Why BT We’ve always been an organisation with a purpose; to use the power of communication to make a better world. You can trace this back to our beginning as pioneers of the world’s first telecommunications company. At our heart we’re a technology company with research and innovation in our bones and a desire to be personal, simple, and brilliant...

  • Informatica/ETL Developer

    3 months ago

    Bangalore, India Yo HR Consultancy Full time

    Profile : Informatica ETL DeveloperExperience : 6 to 8 period : Max 30 days Location : Bangalore Must have : - ETL development - Unix scripting - Oracle : - 7+ years of development experience in delivering ETL/database/programming solution - Good hands-on experience on informatica tool - Strong database knowledge Oracle PL/SQL, tuning - Good...

  • ETL Developer

    2 days ago

    Bangalore, India BT Group Full time

    Why BT We’ve always been an organisation with a purpose; to use the power of communication to make a better world. You can trace this back to our beginning as pioneers of the world’s firs telecommunications company. At our heart we’re a technology company with research and innovation in our bones and a desire to be personal, simple, and brilliant...

  • Snaplogic ETL Engineer

    7 days ago

    bangalore, India Birlasoft Full time

    1. About the Job - The candidate should require mandatory Snaplogic ETL Experience.2. Job Title - Snaplogic ETL Engineer3. Location - Bangalore, Mumbai, Hyderabad, Chennai, Noida, Pune4. Educational Background - UG. B. Tech /B. E in any specialization PG. MCA in Computers5. Key Responsibilities -8 Years of experience in Snowflake Data...

  • SnapLogic Developer

    3 months ago

    Gurgaon/Gurugram/Bangalore, India Huquo Full time

    Job Description :- Minimum 2 years in Snaplogic with Data Engineering/ Data Management, background.- ETL tool Datastage is good to have. - The project is having legacy ETL tool as Datastage and migration to SnapLogic.- Solid background in database systems (such as Oracle, SQL Server, and Teradata) along with strong knowledge of PL/SQL and SQL- DWH concepts...

  • Data Engineer

    3 months ago

    bangalore, India ANKYAH INFINITY PRIVATE LIMITED Full time

    Job Description : - Design, develop, and implement ETL processes to extract, transform, and load data into data lakes or warehouses.- Ensure the accuracy, completeness, and timeliness of data transformations and integrations.- Collaborate with stakeholders to understand and translate business requirements into technical solutions.- Optimize ETL workflows...

  • Snaplogic Etl Engineer

    6 days ago

    Bangalore City, India Birlasoft Full time

    1.About the Job The candidate should require mandatory Snaplogic ETL Experience.2.Job Title Snaplogic ETL Engineer3.Location Bangalore, Mumbai, Hyderabad, Chennai, Noida, Pune4.Educational Background UG. B. Tech /B. E in any specialization PG. MCA in Computers5.Key Responsibilities 8 Years of experience in Snowflake Data warehouse implementation.Design,...

  • Oracle BI ETL Developer

    7 days ago

    bangalore, India SMC Squared India Full time

    Required Skills:5+ years’ years of experience designing, developing, and supporting complex data warehousing, data marts and ETL environments in a senior position. Proven experience in performing conceptual, logical, and physical data modeling in a highly complex environment.5+ years using: Oracle E-Business Suite (12.x or higher)Oracle BI Applications...

  • ETL Architect

    7 days ago

    bangalore, India Tavant Full time

    With 24+ years of experience building innovative digital products and solutions, Tavant provides impactful results to its customers. It has been the frontrunner in driving digital innovation and tech-enabled transformation across a wide range of industries such as Consumer Lending, Manufacturing, Agtech, Media & Entertainment, and Retail in North America,...

  • Sr. Etl Tester

    7 days ago

    Bangalore City, India Qualibar Full time

    Position: Sr. ETL TesterLocation: Hyderabad /Bangalore/ChennaiShift Timing: 1:00 PM 10.00 PMHands on experience in delivery in agile methodology (scrum, lean etc.) Expertise in creation of application specific ETL / DB test strategy and test plan Expertise in database and ETL testing Expert level of knowledge in core concepts of SQL and query. Expertise in...

  • ETL Architect

    3 days ago

    Bangalore, India Tavant Full time

    With 24+ years of experience building innovative digital products and solutions, Tavant provides impactful results to its customers. It has been the frontrunner in driving digital innovation and tech-enabled transformation across a wide range of industries such as Consumer Lending, Manufacturing, Agtech, Media & Entertainment, and Retail in North America,...

  • Oracle Business Intelligence ETL Developer

    4 days ago

    bangalore, India SMC Squared India Full time

    Skills/Experience Requirements5+ years’ years of experience designing, developing, and supporting complex data warehousing, data marts and ETL environments in a senior position. Proven experience in performing conceptual, logical, and physical data modeling in a highly complex environment.5+ years using: Oracle E-Business Suite (12.x or higher)Oracle BI...

  • OBIEE Developer

    3 months ago

    Bangalore, India Randstad India Full time

    The ideal candidate will be extremely proficient in Data Engineering and ETL methodologies and business intelligence solutions. You must be strong in all aspects of data warehousing and data engineering technologies. We believe everyone has a unique story to tell, and these small differences between us have a big impact. When bright, diverse minds come...