In PersonThe description lists Spartanburg, South Carolina, while the ATS location is Greenville, South Carolina.
Data & AnalyticsData Engineering
About the job
Requirements
Extensive experience extracting, transforming, and loading data from databases such as PostgreSQL and Oracle, as well as flat files.
Experience working with large-volume data.
Experience administering and supporting ETL processes for large-scale data warehouses using Informatica PowerCenter.
Knowledge and experience with Informatica PowerExchange.
Experience with Informatica Data Quality Tool is desirable.
Strong experience in data warehousing and ETL using Informatica PowerCenter 9.x or 10.x.
Experience with data modeling using star schema and snowflake modeling, including fact and dimension tables and physical and logical modeling.
Strong skills in data analysis, data requirements analysis, and data mapping for ETL processes.
Hands-on experience tuning mappings and identifying and resolving performance bottlenecks across sources, targets, mappings, and sessions.
Extensive experience designing, developing, and maintaining ETL processes using Informatica PowerCenter 9.x or 10.x.
Experience developing complex SQL queries, unions, multiple-table joins, and views.
Experience with database programming in PL/SQL, including stored procedures, triggers, and packages.
Experience with UNIX shell scripting and Informatica command-line interface commands for starting and scheduling workflows.
Experience creating effective test data and developing thorough unit test cases to verify successful data execution.
Experience with requirements gathering, understanding user requirements, and designing and developing effective solutions.
Good understanding of cloud methodology, technology, and commonly used tools.
Responsibilities
Develop, implement, administer, and support ETL processes for large-scale data warehouses using Informatica PowerCenter.
Tune ETL mappings and resolve performance bottlenecks at the source, target, mapping, and session levels.
Create test data and unit test cases to ensure successful execution of data processes.
Use pager alerts to notify stakeholders after successful workflow completion.
Gather requirements, understand user needs, and design and develop effective solutions.
Support the client’s planned migration from on-premises systems to cloud technologies.
Desired Qualifications
Experience with Informatica Data Quality Tool.
Excellent communication, documentation, and presentation skills using tools such as Visio and PowerPoint.
Job Description
InformaticaPentaho ETL
Location: Spartanburg SC
Duration: Long Term Contract
Required and responsibilities:
• Extensively worked on data extraction, Transformation and loading data from various sources like databases (PostgreSQL, Oracle) and Flat files. • Experience working on large volume data • Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center. • Knowledge and Experience with Informatica Power exchange • Hands on Experience with Informatica ‘s Data Quality Tool is a plus • Strong experience in Data Warehousing and ETL using Informatica Power Center 9.x/10.x • Had experience in data modeling using Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling. • Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes. • Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. • Extensive experience in ETL design, development and maintenance using Informatica Power Center v 9.x/10.x • Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views. • Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages). • Well versed in UNIX shell scripting along with Informatica CLI commands to start, schedule workflows. • Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion. • Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint. • Experience with Requirements gathering, understanding user requirements and coming up with effective designs and development of solution • Client plans to migrate from on-Prem to Cloud soon. So good understanding on Cloud methodology, technology and commonly used tools
Qualifications
Extensive work experience on data extraction and large volume data
Experience working with Informatica Power exchange
Experience in data modeling using Star Schema Modeling, and Snowflake modeling
UNIX shell scripting along with Informatica CLI commands
Good understanding on Cloud methodology, technology and commonly used tools
Additional Information
All your information will be kept confidential according to EEO guidelines.