Senior ETL Developer

Job Summary:

We are looking for an DQ/ETL Developer and this is remote position.

Title: DQ/ETL Developer

Long Term Contract.

Start Date: Early June

Remote

Job Description:

Responsibilities:

Mandatory Skill Sets:

• Informatica Product Suites: Informatica Data Quality (Cloud and On-Prem) used for building data quality mappings/routines that helps in data cleansing and data standardization in most efficient manner.
• Development efficient & highly tuned data cleansing routines
• Should be able to use all CDQ transformations including Address & other Verifier in Cloud version (IDMC)
• Understands CDQ architecture and performance techniques with industry standard coding practices
• Should be able to works with exposing data quality rules as webservices and consume data from third party rest APIs
• Understands the code deployment & knows to automate it
• Build profile on heterogenous data sources – Basic profiling, join data profiling
• Build mapping and rule specifications
• Build and manage Reference data though reference tables
• Informatica Data Management Cloud Data Integration and Cloud Application Integration services are used for data integration and ETL flows and this helps our program with large scale integration projects with minimum infrastructure
• Develop efficient & highly tuned data transformation mappings
• Deploy and manage the secure agents
• Utilize parametrization features in CDI/CAI
• Build, execute/schedule mapping tasks and task flows
• Performance tuning through lookup and other coding best practices
• Knows SCD Types and its implementation in CDI/CAI
• Rest API consumptions
• Process Scheduling Application: Rundeck / Control-M
• Build Jobs for execution of CDQ/ MDM processes
• Build Jobs for execution of Database processes
• Build Jobs for execution of Shell programs on Linux
• Build Workflow Jobs and Daily batch processes
• Setup Alerts/Notification/ Error handling Routines
• Application Start/Stop Routines

Experience:

Required Skills:

• Linux Shell Scripting
• Build Shell Programs for process executions
• Application cleanup actions
• SoapUI
• Postman
• CI/CD through Informatica Dev Ops Platform
• Build Custom Operational Reports and Email Notifications
• OS Infrastructure Alerts
• Application Start/Stop routines
• Documentation:
• GIT
• Strong Documentation Skills
• Follow change management policies
• Databases
• Oracle / Snowflake
• Development
• Project level administration
• SQL Server, MYSQL
• Exposure to NOSQL DBs – Graph / Document Databases
• Functional skills
• Data Modeling
• Logical / Physical Modeling
• Data Integration
• Batch & Realtime Integration
• ETL