The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.

Informatica Developer/Data Modeler

Job Description

Informatica Developer/Data Modeler Summary:

Signature Consultants is looking for an Informatica Developer/ Data Modeler to work on a contract position with one of our clients located in the Boca Raton Area. ETL development experience using Informatica Power Center, Informatica Power Exchange, Informatica Cloud, Informatica Data Quality, Informatica Analyst, Informatica Data Validation (DVO), IBM Cognos Data manager. Hands on experience on Informatica cloud with salesforce.com connectivity and Informatica power center connector for SFDC (CDC).

Responsibilities:

  • Responsible for the design and development of ETL solutions.
  • Work closely with internal business users and business analysts to develop requirements.
  • Design, develop, test, and deploy mappings.
  • Provide production support of Informatica processes.
  • Interpret and implement business requirements for ETL development.
  • Create ETL components for data warehouse and other distributed applications that are optimized and efficient.
  • Perform in-depth unit testing for all enhancements/new development including data analysis for verification of accuracy and performance tuning for optimal execution.
  • Adhere to existing ETL development and load management standards and processes.
  • Manage timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation.
  • Troubleshoot and support ETL systems in a production environment, including resolving issues and deploying bug fixes in a timely manner.

Requirements:

  • 10+ years' experience in data warehousing and data integration projects
  • 10+ years' hands-on experience creating advanced mapping, transformations, and workflows using Informatica PowerCenter
  • Ability to analyze data integration requirements, data sources/targets, business rules, and transformation logic
  • Experience designing and developing data extraction, cleansing, transformation, and loading processes and workflows to load data into various cloud based data warehouses
  • Ability to collaborate with technical and business users to define performance requirements and improve efficiency
  • Strong analytical and problem solving skills
  • Strong SQL knowledge
  • Experience writing / debugging Oracle PL/SQL triggers, procedures, packages, & functions is a PLUS.
  • Hands on data modeling / db design experience using Erwin tool desired.
  • Hands on experience writing / debugging shell scripts / powershell scripts is a must.
  • Excellent communication skills
  • Experience in ETL architecture and ETL methodology.
  • Experience in database architecture, data modeling, database design and implementation.
  • Proficient in Teradata application utilities including Multi load, Fast Load, Teradata Parallel Transporter and Bteq.
  • Experience in advanced Informatica techniques like Push down optimization, Partitioning, Change data capture, Reference Table Manager, Master Data Management, User defined functions.
  • Proficient in loading large volumes of data with best ETL and Database techniques to accommodate challenging business SLA.
  • Experience in Enterprise Scheduling tools like Zeke, Autosys, UC4, Tidal.
  • Able to communicate with the business and translate business needs into data driven solutions

Technical Proficiencies:

  • OS: IBM AIX, HP-UX, Linux, Windows 2000/XP, Windows NT
  • Hardware: IBM PC and Compatibles
  • Database: Teradata, Oracle, SQL Server, DB2, Attunity
  • Languages: SQL, PL/SQL, UNIX Shell scripting, SQL Server T/SQL
  • Tools: SAS, Teradata Application Utilities, SQL Assistant, DB Visualizer SQL Loader, SQL Navigator, Toad
  • DW Tools: Informatica Power Center, Power Exchange, IDQ, Analyst, DVO, Informatica cloud Web Services, SalesForce
  • Scheduling Tools: Zeke, ECS
  • DB Modeling Tool: Erwin

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the seventh consecutive year, Signature was voted as one of the 'Best Staffing Firms to Work For' and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 26 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com.

Job Requirements

 

Job Snapshot

Location US-FL-Boca Raton
Employment Type Contractor
Pay Type Year
Pay Rate N/A
Store Type IT & Technical
Apply

Company Overview

Signature Consultants

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the eighth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is the 15th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 26 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Learn More

Contact Information

US-FL-Boca Raton
Snapshot
Signature Consultants
Company:
US-FL-Boca Raton
Location:
Contractor
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
IT & Technical
Store Type:

Job Description

Informatica Developer/Data Modeler Summary:

Signature Consultants is looking for an Informatica Developer/ Data Modeler to work on a contract position with one of our clients located in the Boca Raton Area. ETL development experience using Informatica Power Center, Informatica Power Exchange, Informatica Cloud, Informatica Data Quality, Informatica Analyst, Informatica Data Validation (DVO), IBM Cognos Data manager. Hands on experience on Informatica cloud with salesforce.com connectivity and Informatica power center connector for SFDC (CDC).

Responsibilities:

  • Responsible for the design and development of ETL solutions.
  • Work closely with internal business users and business analysts to develop requirements.
  • Design, develop, test, and deploy mappings.
  • Provide production support of Informatica processes.
  • Interpret and implement business requirements for ETL development.
  • Create ETL components for data warehouse and other distributed applications that are optimized and efficient.
  • Perform in-depth unit testing for all enhancements/new development including data analysis for verification of accuracy and performance tuning for optimal execution.
  • Adhere to existing ETL development and load management standards and processes.
  • Manage timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation.
  • Troubleshoot and support ETL systems in a production environment, including resolving issues and deploying bug fixes in a timely manner.

Requirements:

  • 10+ years' experience in data warehousing and data integration projects
  • 10+ years' hands-on experience creating advanced mapping, transformations, and workflows using Informatica PowerCenter
  • Ability to analyze data integration requirements, data sources/targets, business rules, and transformation logic
  • Experience designing and developing data extraction, cleansing, transformation, and loading processes and workflows to load data into various cloud based data warehouses
  • Ability to collaborate with technical and business users to define performance requirements and improve efficiency
  • Strong analytical and problem solving skills
  • Strong SQL knowledge
  • Experience writing / debugging Oracle PL/SQL triggers, procedures, packages, & functions is a PLUS.
  • Hands on data modeling / db design experience using Erwin tool desired.
  • Hands on experience writing / debugging shell scripts / powershell scripts is a must.
  • Excellent communication skills
  • Experience in ETL architecture and ETL methodology.
  • Experience in database architecture, data modeling, database design and implementation.
  • Proficient in Teradata application utilities including Multi load, Fast Load, Teradata Parallel Transporter and Bteq.
  • Experience in advanced Informatica techniques like Push down optimization, Partitioning, Change data capture, Reference Table Manager, Master Data Management, User defined functions.
  • Proficient in loading large volumes of data with best ETL and Database techniques to accommodate challenging business SLA.
  • Experience in Enterprise Scheduling tools like Zeke, Autosys, UC4, Tidal.
  • Able to communicate with the business and translate business needs into data driven solutions

Technical Proficiencies:

  • OS: IBM AIX, HP-UX, Linux, Windows 2000/XP, Windows NT
  • Hardware: IBM PC and Compatibles
  • Database: Teradata, Oracle, SQL Server, DB2, Attunity
  • Languages: SQL, PL/SQL, UNIX Shell scripting, SQL Server T/SQL
  • Tools: SAS, Teradata Application Utilities, SQL Assistant, DB Visualizer SQL Loader, SQL Navigator, Toad
  • DW Tools: Informatica Power Center, Power Exchange, IDQ, Analyst, DVO, Informatica cloud Web Services, SalesForce
  • Scheduling Tools: Zeke, ECS
  • DB Modeling Tool: Erwin

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the seventh consecutive year, Signature was voted as one of the 'Best Staffing Firms to Work For' and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 26 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com.

Job Requirements

 
Mr32s16t3kb13dmn0n5
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
Informatica Developer/Data Modeler Apply now