ETL Developer-SQL Server InComm Holdings
THIS JOB HAS EXPIRED Overview:
InComm is a leading provider of cutting-edge prepaid products, services and transaction technologies to retailers, brands and consumers. InComm supports more than 400,000 points of distribution and helps retailers build prepaid card destinations, connects brands with new markets and gives consumers a simple, secure shopping experience.
InComm stays ahead of emerging trends by analyzing market needs and leveraging its global, innovative commerce platform, go-to-market expertise and extensive partner relationships. With 123 global patents, InComm is headquartered in Atlanta and has offices in North and South America, Europe and the Asia-Pacific region. For more information, visit www.incomm.com or follow us on Twitter at www.twitter.com/incomm.
ETL developer responsible for the complete software development lifecycle (analysis, design, development, testing and migration to production).
Infrastructure includes Informatica/Pentaho, Linux, relational databases, and sql server 2005/2008.
Main responsibilities will be designing and developing new ETL code that will enable downstream reporting teams to fulfill various reporting needs and analyzing, fixing, enhancing existing ETL code.
Perform problem determination (root cause analysis), document the source of problems and their resolution.
Recognize and analyze trends in errors so as to identify and install long term solutions to problems.
Data analysis and ETL design on assigned projects.
Document Requirements, design, and develop Informatica code.
Design, Develop and modify penataho/Informatica workflows and mappings.
Aid in gathering requirements, conducting business analysis, and writing technical design specifications.
Evaluate and design logical and physical databases; define logical views and physical data structures.
Validates test plans and test scenarios; verify test results.
Effectively communicates with project team by escalating problem in a timely manner.
Adheres to company documented development standards and best practices.
5+ years of experience required in related field (i.e. ETL, Data Warehousing and SDLC);
4+ years of experience working with Pentaho BI suite or Informatica ETL tool (design and development).
Strong data analysis skills
Knowledge and experience with designing star schema data models.
Ability to effectively conduct and facilitate design sessions with business customers and internal teams in order to derive data requirements and data design information
Experience in large scale data integration and data warehouse solutions
Experience with sql server database
Exposure to reporting tools and Metadata
SQL and Database related skills (various levels)
Experience with Pentaho BI suite/Informatica/Data stage.
Experience with large databases (>2 TB)
||Atlanta, GA |
THIS JOB HAS EXPIRED