Tag Archives: Informatica jobs in Kansas

#Informatica Developer job opening in Overland Park, KS / Permanent job

Job Overview:

ETL Developer candidate is responsible for designing and developing ETL solutions for interfacing between the source application and the Enterprise Data Warehouse, as well as Data Stores and Marts.

• Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution.
• Analyze & translate functional specifications & change requests into technical specifications.
• Develop, test & implement program logic.
• Translate business needs into end user applications.
• Works with Data Modeler to develop data warehouse models, design specifications, metadata process and documentation
• independently uses development tools and utilities to develop, support, and customize moderately to highly complex business applications.
• Defines, develops, documents and maintains Informatica ETL mappings and scripts.
• Creates and implements Informatica work flows in Unix and Windows environments.
• Defines, develops, documents and maintains procedural and SQL programs
• Develops ETL test plans and tests the ETL code following ETL standards and architecture.
• Assists in the development, execution and documentation of system and integration test plans.
• Performs ETL / Informatica tuning as well as SQL tuning.
• Optimizes Informatica code performance and processing methods.
• Performs design validation, reconciliation and error handling in the load process (initial, incremental).
• Updates and maintains ETL Metadata.
• Provides input into standards and best practices for code development.
• Communicate status / risks to manager regarding delivering solution on time

Contact Information:

Ryan Mac Donald
Senior Technical Recruiter

Saicon Consultants
913-451-1178 #14
rmacdonald@saiconinc.com

Send me a linked in invite to connect for the future:
http://www.linkedin.com/in/ryanmacdonaldtechnicaljobs

For a more complete job list visit my Blog at:
https://ryanmacdonald1.wordpress.com/

Advertisements

Sr. Informatica Developer job opening in Overland park, KS

Job Overview:

• 5+ years“hands-on” Informatica experience; including Informatica version 9.0
• 3+ years“hands-on” Oracle Business Intelligence Applications (OBIA); including Oracle E-Business Suite for Finance and HR modules
• 3+ years experience with Oracle Data Warehouse Console (DAC)
• 5+ years“hands-on” RDMS SQL query experience in at least Microsoft SQL Server and Oracle
• Proficient experience with OBIA Data Warehouse Schema’s for Financials and Human Resources (including General Ledger, Accounts Payable, Accounts Receivable, Projects)
• Functional working knowledge of Oracle E-Business Suite modules, including General Ledger, Accounts Payable, Accounts Receivable, Projects, and Human Resources is a plus
• Supports and troubleshoots production systems as required, optimizing performance, resolving production problems, and providing timely follow-up on problem reports
• 2+ years experience with Oracle Business Intelligence Enterprise Edition (OBIEE) is a plus.
• Informatica developer certification or other equivalent certification training
• Codes, tests, and implements complex programs according to IT standards and Oracle best practices.
• Data Warehouse and Database Systems: Theory, architecture, design, configuration, operation, security, and tools
• Relational and dimensional database theory, architecture, design, and tools: Logical and Physical modeling, Dimensional modeling, Star and Snowflake schema, OLAP processing
•Analytical/Problem Solving: Intellectual capacity and ability to gather, sort and analyze data and then develop logical conclusions; critical thinking skills; familiar with problem solving tools/techniques and able to communicate options, conclusions, and recommendations to both the business and the technology teams
•Interpersonal/Communication: articulate and capable of conveying ideas clearly/concisely; sensitive to needs of the audience; ensures the customer, as well as service areas within Technology & Systems are kept informed of plans, status, and current problems/challenges; manages around internal politics; empathetic, good listener
• Champions quality of data in the warehouse
• Works with Data Analyst on physical model designs for star schemas
• Mentors others through issues and if needed, facilitate resolution
• Takes the established projects and drives them to completion, on time and on budget meeting the customer’s expectations and objectives
• Must be a constant learner. Staying up to date on industry knowledge and striving to learn about new and emerging technologies and trends in the Exhibition, Information Technology (IT) industries as well as business practices and trends (including regulatory and compliance requirements)
• Familiarity with technology product & service offerings by vendors providing products and services in the data warehouse and database space
• Possess or has made progress towards receiving a TDWI Certification or equivalent experience
• 2+ year’s management of technical/support personnel
• 2+ years project management
• 5+ years experience of successful data warehouse development
• Experience working in an enterprise data warehouse environment

Contact Information:

Ryan Mac Donald
Senior Technical Recruiter

Saicon Consultants
9300 W 110th Street / Suite 650
Overland Park, KS 66210
913-451-1178 #14
rmacdonald@saiconinc.com

Saicon Job Listings:
https://ryanmacdonald1.wordpress.com/

Send me a linked in invite to connect for the future:
http://www.linkedin.com/in/ryanmacdonaldtechnicaljobs

%d bloggers like this: