For Recruiters

ETL Developer

Cognizant
Singapore
Posted about 21 hours ago Permanent Competitive
ETL Developer
Job Summary:

• Technical Skills in order of priority: Informatica 9.x/10.x , Hadoop Programming(Sqoop, Hive, Spark,Blaze), Strong SQL, PL/SQL,Microsoft AZURE, Microsoft ADF, Azure Data services, Azure Monitoring ,MS SQL server, RDMS Experience.
• Hands on experience in ETL Development.
• Hands on experience with Sqoop, Hive, Spark and Blaze technologies.
• Hands on experience in Microsoft ADF.
• Hands on experience in Informatica administrator, Informatica Big Data Management (BDM) and related sub-products Administration.
• Must have knowledge on Integration of informatica with Hadoop system (kerberized and non kerberized)
• Must have Functional Knowledge on life science.
• Strong analytical and problem-solving skills.
• Strong understanding of ETL Development best practices, Strong understanding of Database Concepts, Performance Tuning in SQL and Informatica.
• Strong knowledge of technology platforms and environments.
• Proven ability to work independently in a dynamic environment with multiple assigned projects and tasks.
• Ability to develop complex mappings and workflows in accordance with requirements.
• Outstanding ability to communicate, both verbally and in writing.

Key Responsibilities:

• Extract data from various sources like HDFS, Flat Files, JSON and relational databases and ingest into Hive and other databases.
• Ingest data into Hive and other relational databases and generated output reports in form of csv and excel files.
• Good understanding of Hive Database and Hadoop file system (HDFS)
• Push down jobs on Hadoop engines (Spark and Blaze) and monitor jobs queued on Yarn
• Perform Integration of data from various sources to the targets by implementing business rules to enhance the performance.
• Experience in analysis of source systems, business requirements and identification of business rules and creating low-level specifications.
• Data integration from system like Veeva alignment and workday to loading the data using informatica PowerCenter 10.x to Axtria Sales IQ.
• Experience in developing, unit testing and supporting various testing phases for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Experience on architectural design to migrate on-premises informatica PC 10.x system to Microsoft Azure ADF.
• Responsible for development of workflows, activities, resources, server set up and monitoring resources in ADF.
• Experience in creating batch files and scripts to run workflows and manage dependencies across workflows.
• Perform tuning of mappings/session at database and Informatica level to improve ETL load timings.
• Ability to apply business logic and created complex mappings using various transformations like SQL, Expression, Router, Aggregator, Filter, Joiner, Union, Rank, connected/unconnected Lookup,Update strategy, Sequence generator, connected/unconnected Stored Procedure, Transaction Control and Source Qualifier.
• Ability to Implement various reusable and non-reusable tasks like Session, Command, Email, Event wait, Event Raise, Decision, Timer and Control.
• Experience on Implementing performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Ability to Create reusable transformations, mapplets and worklets for code reusability, use of parameter file , mapping/workflow parameters and variables, use Informatica debugger to troubleshoot issues, create summary tables to display statistics of all jobs for users.
• Ability to develop complex mappings and workflows in accordance with requirements, Error Handling, Error logging mechanism.
• Ability to Create and configure Informatica Domain and Application Services: Model Repository, Data Integration service, Metadata access, Content management, Monitoring Model repository, Analyst, Search, Catalog service
• Ability to Upgrade Informatica BDM to newer versions, Apply hotfixes and service packs
• Expert knowledge of Informatica PowerCenter 9.x or higher administration on Linux/Unix and Windows server platforms
• Ability to Implement SSL and Enable Secure Domain and configure secure communication between the services, client components and the domain.
• Ability to Use HTTPS for secure connection to the domain and the application services
• Ability to Create and manage Users, Connections, Folders and manage privileges on them, Manage logs, nodes, operating system profiles, and licenses
• Monitor Data Integration Service jobs and applications.
• Expert on configuration of LDAP and Native authentication of application
• Ability to deploy Informatica code using export/import and deployment group methods
• Proven ability to work independently in a dynamic environment with multiple assigned projects and tasks.

Job Requirements:

• Informatica 9.x/10.x, Informatica Administrator, Informatica Big Data Management (BDM) and related sub-products Administration , Hadoop Programming (Sqoop, Hive, Spark, Blaze),Strong SQL,PL/SQL, Hive Database and Hadoop file system (HDFS) ,RDMS Experience, Microsoft Azure ,Microsoft ADF, MS SQL, SSIS, Azure Data services, Azure Monitoring
• Data Modelling: Star/Snowflake
• Databases: Oracle SQL, DB2, MS SQL Server
• Programming: SQL, PLSQL, UNIX, Unix Shell Scripting
• Scheduling tools: Control M, Informatica scheduler, Crontab
• OS: Linux, Windows, Unix
• Other tools: Putty, WinSCP, GIThub, AS400, Aldon, Dropbox, JIRA, ServiceNow, AXTRIA SalesIQTM
• Domain: Life Science

#L1-SG1

Employee Status : Full Time Employee

Shift : Day Job

Travel : No

Job Posting : May 10 2022

About Cognizant
Cognizant (Nasdaq-100: CTSH) is one of the world's leading professional services companies, transforming clients' business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant is ranked 185 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com or follow us @Cognizant.
Job ID  COGNGLOBAL00048607841
More Jobs From Cognizant
Cognizant
Intellimatch - Application Support
Cognizant
Singapore
about 21 hours ago Full time Competitive
Cognizant
Senior Business Analyst - Private Banking
Cognizant
Singapore
about 21 hours ago Full time Competitive
Cognizant
Senior Consultant - Payments
Cognizant
Singapore
about 21 hours ago Full time Competitive
Cognizant
Data Consulting Lead
Cognizant
Singapore
about 21 hours ago Full time Competitive
Cognizant
Senior Consultant - Trade Finance
Cognizant
Singapore
1 day ago Full time Competitive
Cognizant
Business Analyst, Digitalization
Cognizant
Singapore
1 day ago Full time Competitive
Cognizant
Senior Consultant - Data Analytics
Cognizant
Singapore
1 day ago Full time Competitive
Cognizant
Finastra GPP Implementation Lead
Cognizant
Singapore
1 day ago Full time Competitive
Cognizant
Deal Shaper - Cloud, Infrastructure & Security
Cognizant
Singapore
1 day ago Full time Competitive
Cognizant
Senior / DeltaV Automation Engineer
Cognizant
Singapore
1 day ago Full time Competitive
More Jobs Like This
Ameriprise Financial, Inc.
Software Engineer - Informatica ETL Developer
Ameriprise Financial, Inc.
USA, Minneapolis
ETL Developer
DXC Technology
Malaysia, Kuala Lumpur
ETL Developer
DXC Technology
Malaysia, Kuala Lumpur