Veracity Software Pvt. Ltd. ยท 5 months ago
ETL Developer
Jersey City, NJ
Full-time
Hybrid
Mid LevelVeracity Software Pvt. Ltd. is seeking an ETL Developer to create complex ETL workflows and data mappings. The role involves developing Unix scripts, performing unit testing, and coordinating with a distributed team while utilizing tools like Informatica Powercenter and MuleSoft.
Information Technology & Services
Responsibilities
Demonstrate technical and analytical skill in developing complex ETL workflows using Informatica Powercenter
Create data mapping to ingest data from disparate data sources ranging from flat files to RDMS, Hive or REST APIs
Responsible for developing Unix scripting
Proficiency in MuleSoft tools desired
Work independently with minimum supervision
Develop test cases and perform unit testing
Interact and co-ordinate with distributed team
Provide regular task status updates to the management
Technically strong in Informatica Power center
Technically strong in performance tuning of targets, sources, mappings and SQL queries
Conceptually good in PL/SQL, Functions, and writing complex SQLs, and creating and exposing views/materialized views
Strong in UNIX commands and Scripting
Good in MuleSoft Integration
Expert in PL/SQL programming and Database design, with strong data analysis skills
Self-managed and proactive communicator
Unix scripts
Autosys
Informatica for ETL
Previous experience of working in a data warehouse project is a plus
Python programming
Tableau/reporting experience
Experience in working with Mulesoft and other API technologies
Source control repository - SVN/BitBucket, Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible)
Qualification
Required
Demonstrate technical and analytical skill in developing complex ETL workflows using Informatica Powercenter
Create data mapping to ingest data from disparate data sources ranging from flat files to RDMS, Hive or REST APIs
Develop Unix scripting
Proficiency in MuleSoft tools
Work independently with minimum supervision
Develop test cases and perform unit testing
Interact and co-ordinate with distributed team
Good communication skills
Provide regular task status update to the management
Technically strong in Informatica Power center
Technically strong in performance tuning of targets, sources, mappings and SQL queries
Conceptually good in PL/SQL, Functions, and writing complex SQLs, and creating and exposing views/materialized views
Strong in UNIX commands and Scripting
Good in MuleSoft Integration
Expert in PL/SQL programming and Database design, with strong data analysis skills
Self-managed and proactive communicator
Unix scripts
Autosys
Informatica for ETL
Preferred
Source control repository - SVN/BitBucket
Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible)
Previous experience of working in a data warehouse project
Python programming
Tableau/reporting experience
Experience in working with Mulesoft and other API technologies
Company
Veracity Software Pvt. Ltd.
At Veracity, if you have an idea you want to validate, a product you need to build, or an existing product that needs optimization, our teams are trained to jump in wherever needed.
Founded in 2010
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase