ETL Developer
Location: Dayton, OH
Duration: 1 year contract
Pay: $45
Required Competencies / Knowledge / Skills:
- ETL development
- Java development experience desired
- Unit Test Framework experience required
- Oracle Database knowledge required
- Unix experience required
- Metadata solutions or tool experience preferred
- Communication skills both written and verbal
- Ability to work independently and within a team environment
- Critical listening and thinking skills
- Decision making/problem solving skills
- Leadership experience and skills
Desired Knowledge:
• Informatica 9+ ETL
• Informatica 9+ Multi Domain MDM
• PL/SQL
• Oracle 12c
Job Duties
Create data validation processes within the ETL or Batch cycle; Performs data profiling of source data in order
to identify data quality issues and anomalies, business knowledge embedded in data; natural keys, and meta
data information.
Develops, maintains, and integrates automated processes which validate extracted data from standardized or
varied data sources; automated verification of transformed data used for storing in proper formats and
structures for querying and analysis; automated validation of loaded data into target data structures,
Operational data store (ODS), data mart, or data warehouse;
Creates data validation rules on source data to confirm the data has correct and/or expected values.
Sorts and Aggregates records into rollup where multiple records are represented; Creates surrogatekey values
to use in place of multiple natural keys; Turns multiple columns into multiple rows or vice–versa (Transposing or
Pivoting); Splits multivalued column data into multiple columns; Disaggregates repeating columns into
separate detail table(s); Creates lookup tables; Looks up and validates reference information as part of data
validation.
Creates and applies data validation step process in order to perform partial, full or no record's rejection; Writes
processes which handle exceptions and/or move records exceptions to alternate Transform step(s)
Creates process cleanup and automated validation after complex ETL processes which release resources used
to run ETL; Creates processes to archive data.
Responsible for unit testing, implementation of automated validation solution, and continuous maintenance and
support of existing solutions.
- Ability to successfully design, deploy and evolve ETL solutions to meet business requirements using
- Informatica 8.x or higher.
- Experience with performance tuning Informatica mappings and sessions.
- Strong background in Oracle 11g.
- Experience building SQL queries, including creating subqueries, minus/union, and inline queries
- Must be able to troubleshoot problems and have knowledge of how to incorporate techniques for data
- auditing and quality.
- Must assist in the development of best practices and guidelines to ensure complete, accurate, and
- maintainable solutions.
- Understanding of crosssystem reconciliation patterns
- Understanding of audit, balance and control from an ETL perspective
- Familiarity with Master Data Management, specifically customer data, matching, merging, tokenization
- and fuzzy searching
- Good understanding of throughput/performance testing
- Ability to influence team at design time to ensure best practices are followed, build for performance and to ensure testability.
Thanks & Regards,
Divya
Sr. Resourcing Specialist
IDC Technologies, Inc.
1851 McCarthy Boulevard, Suite 116, Milpitas, CA 95035
Phone : 4088685125
Fax : 4086086088
Email: divya.r@idctechnologies.com
Website: www.idctechnologies.com
You received this message because you are subscribed to the Google Groups "CVMSCRM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cvmscrm+unsubscribe@googlegroups.com.
To post to this group, send email to cvmscrm@googlegroups.com.
Visit this group at https://groups.google.com/group/cvmscrm.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment