14 days old
2018-01-042018-02-01

Informatica ETL Integration Specialist

Kansas City, MO 64105
  • Job Code
    594323

Designs, architects, and implements data warehouse ETL solutions for Business Intelligence. Works with business teams, BI Team, DBAs, ETL developers, and report developers to deliver comprehensive ETL processes across products and solutions. Develop, test and package ETL processes using standard SQL and other enterprise ETL tools.


This position will be closely involved in all aspects of the software development life cycle as part of a team of software developers. This individual will primarily support BI projects by developing and executing ETL tasks, implementing data quality analysis, data migration, and data cleansing. This position will work closely with the Business Intelligence team and Business Analysts acquiring clear business requirements, outlining and designing robust solutions, and developing code that is high quality, error free and on time meeting milestones as defined and agreed upon.


Job Duties:



  • Translate business and functional requirements to technical specifications in the context of legacy data warehouse and Azure Data Warehouse, and implement efficient and repeatable technical solutions using highly optimized and standards-compliant SQL queries.
  • Collaborate with business/data analysts, data architects, developers, database administrators to create conceptual, logical, and physical data models for Business Intelligence reporting databases.
  • Solid understanding of relational database concepts, data warehousing, OLAP, and database architecture and design.
  • Demonstrated ability to understand logical relationships and to ensure that programming faithfully replicates these relationships
  • Install, configure and upgrade Informatica Components.
  • Support the design, development, and implementation of data architecture for historical reporting and analysis. Defines the content and structure of the database (schema) and advises users on efficient techniques for extracting data.
  • Design Informatica based customized ETL solutions to support the creation of databases, table spaces, tables, indexes, triggers, procedures, and other database objects.
  • Optimize data transfers between internal source databases to Azure Cloud data warehouse, based on specific Business requirements.
  • Develop and apply advanced research techniques in the investigation and resolution of highly complex compatibility and interface design considerations.
  • Creative problem-solving and root cause analysis skills. Ability to manage multiple projects and shifting priorities in a fast paced environment.
  • Implement changes and provide post-implementation user support and system support.
  • Work with project teams to refine business requirements that produce well-designed and developed solutions.
  • Document and maintain project specific processes and data flows, data dependencies, data definitions, metadata and relevant business rules. Establish data dictionaries to support the buildout of a data governance infrastructure.
  • Maintain and manage revisions of code in production, testing and development environments.
  • Design and develop OLAP models consisting of certified multi-dimensional cubes and datamarts that allow the business the ability to build custom reports and analytical dashboards.


Requirements:



  • Bachelor's Degree in Engineering, Computer Science, Information Systems or related field with
  • programming coursework or equivalent database development experience.
  • 7+ years of experience in IT Industry involving Analysis, Design, Development, Integration, Issue resolution, Maintenance, Production implementation and Testing.
  • 5+ years of experience in an Informatica ETL developer role with exposure to interfacing with DB2, Salesforce, SAP, SQL Server and Flat Files. Develop advanced ETL transformations supporting the creation of Business Intelligence data warehouses On Premise or in the Cloud.
  • 3+ years of experience with Rail/Transportation related databases (Preferable)
  • Advanced knowledge in the following; Informatica Power Center 9.x, Informatica Data Quality 9.x, Informatica Developer Client, Informatica Analyst tool 9.x, Informatica Power Exchange.
  • Expert in writing complex SQL queries and stored procedures
  • Experience with database development software tools like Optim, Query Tool, TOAD etc
  • Familiar with Windows operating system, shell scripting.
  • Demonstrated ability to communicate technical recommendations to a non-technical audience in a clear and concise manner
  • Demonstrated ability to test and validate programming steps
  • Demonstrated ability to evaluate and interpret complex data sets
  • Demonstrated analysis, programming, and problem solving skills
  • Ability to work both independently and as part of a project team

Categories

  • Information Technology

Randstad utilizes a technology-driven focus with a human touch to provide better staffing and business solutions to organizations around the world. Our team of experts match professionals with available career opportunities in a variety of fields.

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Informatica ETL Integration Specialist

Randstad Technologies
Kansas City, MO 64105

Share this job

Informatica ETL Integration Specialist

Randstad Technologies
Kansas City, MO
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast