ETL/ Data Engineer (Talend) at globe teleservices · Bengaluru (Bangalore) · 5 - 10 years · ₹20L - ₹25L / yr · Profitable · Posted 14 Sep 2023

Good experience in the Extraction, Transformation, and Loading (ETL) of data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager,
Designer, Workflow Manager, Workflow Monitor, Metadata Manager), Power Connect as ETL tool on Oracle, and SQL Server Databases.
Knowledge of Data Warehouse/Data mart, ODS, OLTP, and OLAP implementations teamed with
project scope, Analysis, requirements gathering, data modeling, ETL Design, development,
System testing, Implementation, and production support.
Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts
and Dimensions
Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,
Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
Developed mapping parameters and variables to support SQL override.
Created applets to use them in different mappings.
Created sessions, configured workflows to extract data from various sources, transformed data,
and loading into the data warehouse.
Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
Modified existing mappings for enhancements of new business requirements.
Involved in Performance tuning at source, target, mappings, sessions, and system levels.
Prepared migration document to move the mappings from development to testing and then to
production repositories
Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex
SQL queries using PL/SQL.
Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica
/Talend sessions as well as performance tuning of mappings and sessions.
Experience in all phases of Data warehouse development from requirements gathering for the
data warehouse to develop the code, Unit Testing, and Documenting.
Extensive experience in writing UNIX shell scripts and automation of the ETL processes using
UNIX shell scripting.
Experience in using Automation Scheduling tools like Control-M.
Hands-on experience across all stages of Software Development Life Cycle (SDLC) including
business requirement analysis, data mapping, build, unit testing, systems integration, and user
acceptance testing.
Build, operate, monitor, and troubleshoot Hadoop infrastructure.
Develop tools and libraries, and maintain processes for other engineers to access data and write
MapReduce programs.

About globe teleservices
About
Similar jobs (7)
Job Description:
Skill Set
Informatica, IDMC, Informatica MDM
Experience
4-6 Years
Location
Faridabad, Haryana, India
Work Mode- Hybrid
Job Description
Roles & Responsibilities
- Lead project team members through all activities required to successfully deliver Informatica.
- Define technical specifications for workflows and business rules.
- Prepare detailed design documents for data migration.
- Configure, build and unit test Informatica components, including data structures, roles, workflows, and portals.
- Train and mentor colleagues in Informatica implementation activities and best practices.
- Support integration, system, and user acceptance testing.
- Accountable for the Master Data Management, Technical Architecture, providing data modeling solutions and recommendations.
- Profile & Analyze Source Data usage using ETL tool.
- Automation, job scheduling, dependencies, monitoring.
- Configure/Script Business rules and transformation rules in ETL
- Data pipeline using IICS
- Hands on experience in Informatica MFT, Data Exchange (DX),and Data Transform (DT) modules
- Integration experience using various adapters (MLLP, SOAP, REST, SFTP, ODBC) will be essential.
- Strong knowledge and experience with developing complex SQL Queries, stored procedures, and triggers for RDBMS systems.
- Experience in administering, supporting, and performance tuning using Informatica.
We are looking for Data engineer with strong expertise in Data warehousing to join our team.
Key skills : ab initio, ssis , Informatica, Hadoop and Teradata

Job Description: Informatica IDMC & Snowflake Developer
Experience: 6+ Years
Required Skills: Informatica IDMC, ETL, Data Warehousing, Snowflake, SQL
Contract Duration: 2 months
Required Technical Skills
- Informatica: Strong hands-on experience with Informatica IDMC, Cloud Data Integration (CDI), Cloud Application Integration (CAI), Mass Ingestion (MI).
- ETL / ELT: Strong understanding of ETL architecture, data integration patterns, incremental loading, and error-handling strategies.
- Data Warehousing: Good understanding of dimensional modelling, data marts, fact and dimension tables, and data warehouse design principles.
- Snowflake: Hands-on experience with Snowflake architecture, SQL, data loading, transformations, performance tuning, and warehouse optimization.
- SQL: Strong proficiency in complex SQL queries, analytical functions, views, stored procedures, and query optimization.
- Database Development: Experience creating and maintaining database objects, validating data, reconciling datasets, and troubleshooting performance issues.
Candidate Profile
- 6+ years of hands-on experience in ETL/ELT development and data integration along with IDMC, Snowflake, Data Warehousing and SQL.
- Strong analytical, problem-solving, and communication skills.
- Ability to work independently, manage priorities, and collaborate effectively with cross-functional teams.
- Proven ability to deliver high-quality, scalable, and maintainable data solutions in an Agile Environment.
Hiring: Informatica IDMC / IICS Developer
Location: Faridabad, Haryana
Experience: 4–7 Years
Must-Have:
• Informatica IDMC / IICS
• Data Integration & Application Integration (CAI)
• ETL / Data Pipelines / Data Migration
• REST, SOAP, SFTP & API Integration
• Strong SQL, Stored Procedures & RDBMS
• Job Scheduling, Monitoring & Performance Tuning
Good to Have: Informatica MFT, DX, DT, MDM & Data Quality
Position: Backup Data ETL Developer
Experience: 6–9 Years
Location:Mumbai
Employment Type: Full-time
Job Description:
We are looking for a Backup Data ETL Developer with 6–9 years of experience in designing, developing, and supporting data extraction, transformation, and loading (ETL) processes.
The candidate should have strong hands-on experience with Hadoop, Spark, Informatica, and Snowflake, along with expertise in large-scale data processing and data integration technologies.
Key Skills:
Hadoop
Spark
Informatica
Snowflake
ETL Development
Data Integration
Data Transformation
Large-Scale Data Processing
ETL Workflows and Data Pipelines
Troubleshooting and Problem-Solving
Strong analytical and collaboration skills
Role Overview
We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.
Key Responsibilities
- Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
- Build and maintain data models to support business processes, reporting needs, and integration workflows.
- Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
- Work closely with cross-functional teams to gather data requirements and understand business logic.
- Develop and execute integration test plans, including functional, data validation, and regression testing.
- Support data migration activities, including extraction, transformation, and loading (ETL).
- Monitor and troubleshoot integration issues, ensuring timely resolution.
- Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
- Ensure integration security, data integrity, and compliance with organizational standards.
Required Skills & Qualifications
- 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
- Hands-on experience with data mapping, data modelling, and database schema design.
- Proficiency in SQL (complex joins, stored procedures, performance tuning).
- Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
- Strong analytical and problem-solving skills.
- Experience with API-based integrations (REST/SOAP) is a plus.
- Familiarity with testing methodologies for integrations and data validation.
- Ability to work with business users, understand workflows, and translate requirements into technical solutions.
Preferred Qualifications
- Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
- Knowledge of JSON, XML, CSV transformation.
- Exposure to scripting languages (Python, Shell).
- Experience in Agile/Scrum environments.
- Prior involvement in ERP implementation or upgrade projects.
Competencies
- Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
- Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
- Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
- Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
- Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.
Why Join Us?
- Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
- Work on impactful projects that make a difference across industries.
- Opportunities for professional growth and continuous learning.
- Competitive salary and benefits package.
Application Details
Ready to make an impact? Apply today and become part of the QX Impact team!
Navtech is a premier IT software and services provider. Our mission is to increase public cloud adoption and build cloud-first solutions that become trendsetting platforms of the future.
We have been recognized as the Best Cloud Service Provider by GoodFirms for delivering quality services and results. We strive to innovate and push technology and service boundaries to provide best-in-class technology solutions to our clients globally.
We are a fast-growing company serving clients across the United States, UK and Europe. You will work with a team of talented developers, quality engineers and product managers who are passionate about building impactful technology solutions.
About the Role
We are looking for an experienced Senior SQL Server / SSIS Engineer to design, develop, maintain and optimise database solutions and ETL workflows.
The ideal candidate should have strong hands-on experience with Microsoft SQL Server, SSIS package development, T-SQL programming, database performance tuning and data migration.
You should be comfortable working with existing database systems, troubleshooting complex issues, improving performance and ensuring data integrity, security and availability.
Key Responsibilities
- Design, develop and maintain SQL Server databases, database objects and logical data models.
- Develop, deploy and maintain SSIS packages for ETL processes and data integration.
- Build and optimise complex SQL queries, stored procedures, functions, views and triggers.
- Design and implement data extraction, transformation and loading workflows across multiple systems.
- Perform database migrations, data transformations and validation activities.
- Monitor and troubleshoot SQL Server databases, SSIS packages and SQL Server Agent jobs.
- Identify and resolve performance bottlenecks through query optimisation, indexing and execution plan analysis.
- Handle database administration activities, including upgrades, backups, recovery and maintenance.
- Ensure database performance, security, availability and data integrity.
- Troubleshoot database locking, blocking and resource utilisation issues.
- Collaborate with developers, QA engineers and other stakeholders to understand database requirements.
- Maintain technical documentation for database structures, ETL workflows and processes.
- Provide production support and proactively identify opportunities to improve database performance and reliability.
Who Are We Looking For?
- 6–10 years of experience in SQL Server development and database engineering.
- Strong hands-on experience with Microsoft SQL Server, preferably SQL Server 2016/2017 or above.
- Hands-on experience in developing, deploying and maintaining SSIS packages.
- Strong understanding of ETL processes, data integration and data migration.
- Advanced knowledge of T-SQL, stored procedures, functions, views and triggers.
- Experience in database performance tuning, query optimisation, indexing and execution plans.
- Experience in SQL Server monitoring, troubleshooting and resolving database performance issues.
- Good understanding of SQL Server Agent jobs, database backups, recovery and maintenance.
- Experience resolving database locking conflicts, blocking and resource utilisation issues.
- Knowledge of SQL Server system tables and Dynamic Management Views (DMVs).
- Experience with PowerShell scripting and automation is preferred.
- Exposure to AWS RDS, Azure SQL or other cloud database environments is an advantage.
- Knowledge of PostgreSQL or NoSQL databases is a plus.
- Experience leading or mentoring junior developers is preferred.
- Bachelor's or Master's degree in Computer Science, Software Engineering, IT or a related field.
- Excellent analytical, logical, troubleshooting and communication skills.
Good to Have
- Experience with SSRS or SSAS.
- Knowledge of AWS RDS or Azure SQL.
- Experience with PowerShell scripting.
- Exposure to PostgreSQL or NoSQL databases.
- Relevant Microsoft SQL Server certifications.
Why Navtech?
- Performance reviews and appraisals twice a year.
- Competitive compensation package with additional bonuses and benefits.
- Opportunities to work with renowned clients across the US, UK and Europe.
- Medical insurance coverage for self and immediate family.
- Opportunity to work with a culturally diverse and collaborative team.
- Opportunities for continuous learning and technical growth.










