ETL Informatica Developer

ETL Informatica Developer

BCforward is currently seeking a highly motivated ETL Informatica Developer for an opportunity in Jersey City, NJ

Position Title: ETL Informatica Developer

Location: Jersey City, NJ

Anticipated Start Date: ASAP

Please note this is the target date and is subject to change. BCforward will send official notice ahead of a confirmed start date.

Expected Duration: 12 Months.

Job Type: CONTRACT, (Hybrid)

Monday- Friday (5x8)

A candidate who is authorized to work independently

Pay Range: $65- $70/hr.

Please note that actual compensation may vary within this range due to location, experience, and job responsibilities, and does not encompass additional non-standard compensation (e.g., benefits, paid time off, per diem, etc.).

ROLE SUMMARY

Description:

• The IICS (Informatica Cloud) and Snowflake Business Intelligence ETL Developer is a key, hands-on role that will develop and deliver solutions that enable the collection, transformation, and management of information from one or more sources. This role will be integral in migrating the data warehouse to re-platforming the ETL to Informatica Cloud IICS.
  The ideal Developer for this role can handle end-to-end Data Warehouse and Data Integration by taking into consideration the business cases, objectives, and requirements. The technical domain of the position includes Snowflake cloud data warehouse and the Data Integration, App & API Integration, Data Replication, and Mass ingestion services of Informatica Intelligent Cloud Services. In addition, the responsibilities will include data integration, data architecture, information delivery, infrastructure, testing, and performance tuning for all components of the project.
  
  Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
  Creates ETL Mappings, Mapplets, Workflows, and Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
  Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
  Performs source system analysis as required.
  Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
  Implements versioning of the ETL repository and supporting code as necessary.
  Develops stored procedures, database triggers, and SQL queries where needed.
  Implements best practices and tunes SQL /queries for optimization.
  Loads and transforms data from various external sources to Relational database using Informatica.
  Worked with complex transformations such as XML, XML parser, Java, and HTTP transformation and have designed SCD typ2 workflows.
  Works with Informatica Data Quality (Analyst and Developer)
  
  
  

Primary Skill
Informatica
Secondary Skill
Oracle SQL / PLSQL
Tertiary Skill
Required Skills
Informatica PowerCenter 10.x, Oracle 11g/12c /19c SQL/PLSQL, Autosys (5-7 years)
Desired Skills
IICS migration from PowerCenter

Benefits:

BCforward offers all eligible employees a comprehensive benefits package including, but not limited to major medical, HSA, dental, vision, employer-provided group life, voluntary life insurance, short-term disability, long-term disability, and 401k.

About BCforward:

Founded in 1998 on the idea that industry leaders needed a professional service, and workforce management expert, to fuel the development and execution of core business and technology strategies, BCforward is a Black-owned firm providing unique solutions supporting value capture and digital product delivery needs for organizations around the world. Headquartered in Indianapolis, IN with an Offshore Development Center in Hyderabad, India, BCforward's 6,000 consultants support more than 225 clients globally.

BCforward champions the power of human potential to help companies transform, accelerate, and scale. Guided by our core values of People-Centric, Optimism, Excellence, Diversity, and Accountability, our professionals have helped our clients achieve their strategic goals for over 25 years. Our strong culture and clear values have enabled BCforward to become a market leader and best-in-class place to work.

BCforward is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability.

To learn more about how BCforward collects and uses personal information as part of the recruiting process, view our Privacy Notice and CCPA Addendum. As part of the recruitment process, we may ask you to disclose and provide us with various categories of personal information, including identifiers, professional information, commercial information, education information, and other related information. BCforward will only use this information to complete the recruitment process.

This posting is not an offer of employment. All applicants applying for positions in the United States must be legally authorized to work in the United States. The submission of intentionally false or fraudulent information in response to this posting may render the applicant ineligible for the position. Any subsequent offer of employment will be considered employment at will regardless of the anticipated assignment duration.

Interested candidates please send resume in Word format Please reference job code 233682 when responding to this ad.

---