Tag Archives: ETL

Sr. #InformaticaDeveloper job openings in #WashingtonDC – Do you know anybody for this job?

Job Overview:

•Informatica Powercenter development experience,
•Oracle 11G PL/SQL expertise
•5 years of experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes
•Experience in developing and deploying Informatica in Unix and Oracle 11g database environment
•Ability to analyze and retrieve metadata from Informatica repository
•Ability to architect an ETL solution and data conversion strategy
•Project experience with developing complex SQL query
•Project experience with dimensional data model
•Strong communication skill to work with client, business users and team members
•Ability to work independently once guidance and goals are provided
•Ability to work well as a team

PREFERRED SKILLS:

•Good understanding of MicroStrategy
•5 years of System Development Lifecycle experience from an engineering perspective
•Knowledge and usage of defect tracking tools and processes for production maintenance
•Knowledge and usage of software versioning/revisions control system such as Subversion SVN
•Solid understanding and practical experience of software development life cycles, with emphasis on release engineering functions

strong>Contact Information:

Ryan Mac Donald
Senior Technical Recruiter

Saicon Consultants
913-553-2667
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/

Saicon Logo

Advertisements

#CranSoft #ETLDeveloper job opening in #Detroit, #Michigan

Job Overview:

The Data Migration specialist is responsible for supporting all data migration activities including data analysis, functional and technical requirements, application development, reporting, and conversions. They should have 1-2 years of experience with the Back Office Associates CranSoft ETL tool to assist in a migration of legacy to system data to SAP.

1). This person will work closely with client stakeholders and subject matter experts to analyze and understand their business objectives and translate those into IT solutions and services
2). Follow a Standardized Development Life Cycle, translate business requirements into technical documentation; build solutions utilizing internal data transformation tools and participant in the user acceptance and approval into production

Preferred Qualifications:

-SAP background
-Experience with other ETL migration tools

Contact Information:

Ryan Mac Donald
Senior Technical Recruiter

Saicon Consultants
913-553-2667
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/

Saicon Logo

#Informatica / #ETLDeveloper / Specialist job opening in #Ogden, #Utah

Job Overview:

•7+ years’ experience in design and development of complex mappings, transformations, sessions and workflows in Informatica PowerCenter
•Strong Informatica Administration experience
•Extensively involved in Informatica Performance tuning methodologies and mechanisms. Should be in a position to provide various solution approaches to tune Informatica code.
•Experience working with large enterprise data models and large volumes of data
•Experience with Oracle DBMS
•Experience with large-scale data conversion and migration projects.
•Experience in creating load scripts to move data from a transactional to analytical models
•Strong experience in performance tuning for Informatica ETL processing
•Expertise in best practices and development standard for ETL
•Manage data quality and consistency through the ETL environment, and resolve issues through appropriate channels
•Establish metadata and audit capabilities through a Common Information Model

Skills are a plus:

•Experience in technical setup and configuration of Informatica.
•Proficiency in relational database design, data mart and data cubes a plus
•Experience in SQL Server
•Experience in, Solaris environment and Unix scripting a plus
•Knowledge of business intelligence and predictive analysis concepts.
•Experience with Rational Software Architect and/or Rational Data Architect.

Contact Information:

Ryan Mac Donald
Senior Technical Recruiter

Saicon Consultants
913-553-2667
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/

Saicon Logo

Sr. #ETLDeveloper job opening in #Lenexa, #Kansas

Job Overview:

-Hiring an ETL specialist for our Enterprise Service BUS team. This individual will be responsible for taking data in a variety of different proprietary formats, mapping it to internal systems, and transforming the necessary data elements to be accepted by internal systems. This work will be accomplished using a 3rd party software application by Aurea Software (formerly owned by Progress Software), specifically the brand names of Sonic, DataXtend, and DXSI.

Qualifications:

This role involves complex data models and mappings so it is imperative that the individual selected be able to understand data structures and work with trading partners and other technical stakeholders to ensure data transformations are stable and accurate. This role is much more complicated than running ETL wizards to get data from point to point – we need someone who can understand the relationships and models of disparate data systems and bring everything together into a single system.

Technically we are looking for someone with a blend of the following:
•Enterprise Service Bus (webMethods, WebSphere, Biztalk, Tibco, Weblogic, Sonic)
•Data Translation (DataXtend, DXSI, Informatica , Altova Mapforce, Kettle)
•XML/ XSLT/ XSD
•Data Modeling/ Data Mapping / Data Transformation

Plus:
•Some experience developing in Java/Eclipse
•Knowledge of ACORD Life message standards

Contact Information:

Ryan Mac Donald
Senior Technical Recruiter

Saicon Consultants
913-553-2667
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/

#BusinessIntelligence #Developer / #Architect / Permanent job opening in #TampaFlorida

Job Overview:

• 4-5+ years IT experience, 5+ years working within SDLC
• Strong skills in ETL, programming, developing SQL, stored procedures, etc. Significant experience with relational AND dimensional modeling and databases (5+ years)
• 3-4+ years experience with the design of ETL solutions integrating multiple source systems and data warehousing
• 3-4+ years development experience with SQL Server/SSIS/SSRS/SSAS
• 2+ years experience serving as a technical lead and providing guidance and leadership to other ETL team members including offshore resources.
• Strong analytical and problem solving skills for design, creation and testing of programs
• Good interpersonal and communication skills to interact with the business and team members; ability to gather and asses business requirements.

Contact Information:

Ryan Mac Donald
Senior Technical Recruiter

Saicon Consultants
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

Permanent Lead ETL Developer / SSIS opening in TampaBay, Florida

Job Overview:

• 8+ years IT experience, 5+ years working within SDLC
• Strong skills in ETL, programming, developing SQL, stored procedures, etc. Significant experience with relational AND dimensional modeling and databases (5+ years)
• 5+ years experience with the design of ETL solutions integrating multiple source systems and data warehousing
• 4+ years development experience with SQL Server/SSIS/SSRS/SSAS
• 2+ years experience serving as a technical lead and providing guidance and leadership to other ETL team members including offshore resources.
• Strong analytical and problem solving skills for design, creation and testing of programs
• Good interpersonal and communication skills to interact with the business and team members; ability to gather and asses business requirements.
• Project management skills
• Ability to work as part of team and independently
• MUST be a U.S. citizen

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

Permanent Lead Business #Intelligence #Developer opening in #TampaBay #Florida

Job Overview:

• 8+ years IT experience, 5+ years working within SDLC
• Strong skills in ETL, programming, developing SQL, stored procedures, etc. Significant experience with relational AND dimensional modeling and databases (5+ years)
• 5+ years experience with the design of ETL solutions integrating multiple source systems and data warehousing
• 4+ years development experience with SQL Server/SSIS/SSRS/SSAS
• 2+ years experience serving as a technical lead and providing guidance and leadership to other ETL team members including offshore resources.
• Strong analytical and problem solving skills for design, creation and testing of programs
• Good interpersonal and communication skills to interact with the business and team members; ability to gather and asses business requirements.
• Project management skills
• Ability to work as part of team and independently
• MUST be a U.S. citizen

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

SSIS / SQL Server Developer #jobopening in Overland Park, KS

Job Overview:

The qualified candidate will be responsible for designing and developing ETL, reporting, and BI solutions. Using Microsoft BI suite, responsibility will include data analysis and transformation, integration between the source applications, Operational and Enterprise Data Warehouses, Stores, and Marts, as well as deployment of the BI functionality to the business consumers.

• Ensure accuracy and integrity of the data and applications through analysis, coding, writing clear documentation and problem resolution.
• Analyze data content and ensure validity of the data structures in support of the ETL and BI needs.
• Analyze and translate functional specifications and change requests into technical specifications.
• Develop, test and implement program logic.
• Translate business requirements into end user applications.
• Works with Data Analyst to develop data warehouse models, design specifications, metadata process and documentation.
• Independently use development tools and utilities to develop, support, and customize moderately to highly complex business applications.
• Define, develop, document and maintain SSIS/SSRS packages, packages configuration and logging, and SSAS cubes.
• Define, develop, document and maintain procedural and SQL programs
• Assist in the development, execution and documentation of system and integration test plans.
• Perform ETL, reporting, and cubes tuning as well as SQL tuning.
• Optimize SSIS/SSRS/SSAS code performance and processing methods.
• Perform design validation, reconciliation and error handling in the load process (initial, incremental).
• Updates and maintains ETL Metadata.
• Provide input into standards and best practices for code development.
• Communicate status / risks regarding time and budget of the solution delivery.
Job Requirements:
• Bachelor’s degree specializing in computer science or equivalent work experience required
• 5+ years work experience in MS BI suite developing ETL and BI solutions utilizing the SSIS/SSRS/SSAS and MDX; experience with DAX preferred
• Experience with multiple programming languages preferred
• 5+ years work experience specializing in transforming XML, Flat files, or other delimited formats into RDBMS
• Good oral and written communication skills
• Strong initiative and organization skills
• Strong customer service and interpersonal skills

Contact Information:

Ryan Mac Donald
Senior Technical Recruiter

Saicon Consultants
9300 W 110th Street / Suite 650
Overland Park, KS 66210
rmacdonald@saiconinc.com

913-451-1178 Extension 14 – Work
913-522-0179 – Cell

Datawarehouse Engineer job opening in Lenexa, KS / SSIS / ETL/ BI

Job Overview:

Looking for someone with 4-5 years of information technology experience with an emphasis in ETL, SSIS, SSAS Business Intelligence with Data warehouse architecture and Kimball Methodology. This person should have extensive hands-on experience in data warehouse architecture, database administration, database application development, and ERP implementations

Contact Information:

Ryan Mac Donald
Senior Staffing Consultant

Midwest Consulting Group
913-693-8200-Office
913-522-0179-Cell
ryanm@mcginfo.com

Midwest Consulting Group partial list of technical openings:
https://ryanmacdonald1.wordpress.com/

ETL / SSIS #BusinessIntelligence Developer job opening in Overland Park, KS

Job Overview:

Looking for someone with 4-5 years of information technology experience with an emphasis in ETL, SSIS, SSAS, SSRS and Business Intelligence with Data warehouse architecture and Kimball Methodology. This person should have extensive hands-on experience in data warehouse architecture, database administration, database application development, and ERP implementations

Contact Information:

Ryan Mac Donald
Senior Staffing Consultant

Midwest Consulting Group
913-693-8200-Office
913-522-0179-Cell
ryanm@mcginfo.com

Midwest Consulting Group partial list of technical openings:
https://ryanmacdonald1.wordpress.com/

ETL / SSIS Business Intelligence Software Developer opening in Lenexa, KS

Job Overview:

Looking for someone with 4-5 years of information technology experience with an emphasis in ETL, SSIS, SSAS, SSRS and Business Intelligence with Data warehouse architecture and Kimball Methodology. This person should have extensive hands-on experience in data warehouse architecture, database administration, database application development, and ERP implementations

Contact Information:

Ryan Mac Donald
Senior Staffing Consultant

Midwest Consulting Group
913-693-8200-Office
913-522-0179-Cell
ryanm@mcginfo.com

Midwest Consulting Group partial list of technical openings:
https://ryanmacdonald1.wordpress.com/

ETL Developer opening in Olathe, KS / Permanent opening

Job Overview:

Looking for someone with 5+ years of ETL / SQL Development for a enterprise level environment. tthis person will have prior experience in the use of SQL or ETL Tools in a Data Warehouse environment. This person will have strong communication skills and the ability to interact with all levels of management and change directions with a moments notice.

Oracle is a plus
SQL Server is a plus
T-SQL is a plus

Contact Information:

Ryan Mac Donald
Senior Staffing Consultant

Midwest Consulting Group
913-693-8200-Work
913-522-0179-Cell
ryanm@mcginfo.com.
ryantier4@comcast.net
http://www.linkedin.com/myprofile?trk=hb_side_pro

Midwest Consulting Group partial list of technical openings:
https://ryanmacdonald1.wordpress.com/