IICS ETL Developer @ DC Consultants

Job Description

IICS ETL Developer About Us: Sankey Solutions is a technology solution and IT consulting firm providing IT and digital transformation services. Solving high-level business problems of the clients using advanced software and methods. Started in 2015 with a team of 4 and has grown to a team of 200+ employees with offices in India, Singapore, and the UK. We work to develop innovative technology solutions with the latest technology in the field of Web Mobility, Application Services, AI, Big Data, Machine Learning, and Predictive and Prescriptive modeling. Responsibilities Informatica PowerCenter developer needed to develop and enhance ETL workflows from various sources to MSSQL database/PostgreSQL DB Perform advanced ETL development activities using Informatica, MSSQL Database tuning, SQL tuning, Informatica Server administration. Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and. requirements. Plans and conducts Informatica ETL unit, SIT and UAT tests. Work with Solution Architect & BAs on end-to-end solution, evaluate and recommend suitable IDMC services. Uses standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work. Works cooperatively with others to resolve data and process issues. Responsible for developing and managing ETL configurable artifacts (code, environment, configuration files, documentation). Provide post-production application support as required. Follow established standards and best practices and provide input for improvement of those processes. Requirements BS/MS degree in Computer Science, Engineering, or a related subject. Must have 3+ years of ETL experience. Current experience with Informatica PowerCenter v10.5+. Experience with migration of Informatica PowerCenter to IDMC. Experience with performance tuning of sources, mappings, targets and sessions. Familiarity with Microsoft SQL Server/PostgreSQL DB. Excellent understanding of T-SQL programming. Ability to work with development and operations teams to tune production queries for optimal performance. Experience with Data Architecture and Data Modeling concepts is a plus. Knowledge of git Source Control. and Knowledge of CI/CD pipelines or deployment automation tools

Employement Category:

Employement Type: Full time
Industry: IT Services & Consulting
Role Category: General / Other Software
Functional Area: Not Applicable
Role/Responsibilies: IICS ETL Developer

+ View Contact

Keyskills:   Informatica PowerCenter ETL PostgreSQL SQL Stored procedures Data modeling Data flow Data Architecture Data Modeling MSSQL Informatica Server administration Functions Data documentation TSQL programming git Source Control CICD pipelines Deployment automation tools