Senior Informatica PowerCenter ETL Developer

BC Forward

Charlotte, NC, United States

26 days ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Compensation

$141,960.0

Working hours

Regular working hours

Job source

www.disabledperson.com

Tech stack

Application Programming Interfaces (APIs) Data Analysis Unit Testing CA Workload Automation Ae Unix Continuous Integration Information Engineering Extract Transform Load (ETL) Data Warehousing Relational Databases Apache Hive Python (Programming Language)

+19 more

Performance Tuning Ansible Shell Script PL-SQL SQL Databases Subversion Tableau (Software) Test Case Unix Commands Informatica Powercenter Build Management IBM UrbanCode Deploy Bitbucket Tools for Reporting Restful APIs Software Version Control Api Management Jenkins Mulesoft

Job description

We are seeking an experienced Application Programmer with strong ETL development expertise to join our data engineering team. The ideal candidate will have deep hands-on experience with Informatica PowerCenter, UNIX scripting, SQL and PL/SQL, and API integrations. You will design and build complex data mappings and workflows, optimize performance, and deliver reliable data movement across diverse sources including flat files, RDBMS, Hive, and REST APIs. You will coordinate with a distributed team, create test cases, perform unit testing, and provide regular status updates to stakeholders. MuleSoft proficiency is desired., * Design, develop, and maintain complex ETL workflows using Informatica PowerCenter.

Create robust data mappings to ingest data from flat files, RDBMS, Hive, and REST APIs.
Develop UNIX scripts to support automation and ETL operations.
Perform performance tuning of sources, targets, mappings, and SQL queries.
Write complex SQL and PL/SQL, including functions, views, and materialized views.
Develop test cases and execute unit testing to ensure quality deliverables.
Collaborate and coordinate with a distributed team and communicate progress to management.
Support API integrations, with emphasis on MuleSoft where applicable.

Requirements

Strong hands-on proficiency with Informatica PowerCenter for ETL development.
Expertise in performance tuning of targets, sources, mappings, and SQL queries.
Proficiency in SQL and PL/SQL, including functions and complex query development, and experience creating views and materialized views.
Strong UNIX command line and shell scripting skills.
Ability to work independently with minimal supervision and deliver regular status updates.
Effective communication and coordination skills for distributed teams.

Preferred Skills:

MuleSoft integration experience and familiarity with API technologies.
Source control with SVN or Bitbucket.
CI/CD tools such as IBM UBuild, Jenkins, IBM UDeploy, or Ansible.
Autosys scheduling experience.
Data warehouse project experience and strong data analysis skills.
Python programming and Tableau or similar reporting tools.

Benefits & conditions

Competitive compensation and benefits.
Opportunities for growth with global clients.
A supportive, inclusive culture that values innovation and people.
Exposure to cutting-edge technologies and projects.

About the company

BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.