Hi,
Hope you are doing great today!
This is Ashutosh, Technical Recruiter from IDC Technologies.
I have a requirement for one of our clients TCS. please find the job
description below.
If you are interested please send me your most updated resume.
*Requirement :- 1*
*Role – SQL Report Developer*
*6+ months contract*
*Denver, CO*
*JD*
*SQL Skills – Moderate to Advanced SQL experience required for SQL Server
-- Mandatory Skill*
- Knowledge of T-SQL Syntax
- Knowledge of SQL Server stored procedures
- Knowledge of merge statements
*SSIS - Moderate SSIS experience -- Desirable Skill*
- Knowledge of how to build stored procedure based SSIS packages
- Knowledge of SSIS parameters, variables, and master package
concepts
- Should know how to implement logging and alerting in SSIS to
notify of failures or certain data conditions
*BI Skills - Moderate experience required -- Desirable skill*
- Environment Planning – Maintain and develop current environment
for existing users as well as prioritize new development requests and
create and execute plans to implement the requests
*Other helpful skills -- Desirable skill*
General knowledge of Salesforce
General knowledge of PowerPivot/Excel
*Requirement :- 2*
*Role – Informatica Developer*
*12+ months contract*
*Eden Prairie, MN*
DETAILS OF THE REQUIREMENT
Role
*Informatica Developer with BO knowledge*
Mandatory Technical / Functional Skills
Role Informatica Developer with BO Knowledge
•experience with data mining and analysis using SQL, PL/SQL, MS Sql Server,
Oracle 10g and higher, Sybase IQ, DB2 data warehouse technology and concepts
•Interacts actively with Data Modelers on Mapping documents and design
process for various Sources and Targets and the relationship involved in
physical, logical design data models.
•Maintained development standards and best practices.
•Prepared detailed functional/technical specifications, and ETL Design
documents from which software applications will be developed and
implemented.
•Designed Data transformation from Transient to Staging, Fact and Dimension
Tables
•Extensively worked on SQL tuning process to increase the source qualifier
throughput by analyzing the queries with explain plan, creating new
indexes, partitions and Materialized views.
•Developed, executed Test Plans and Test Cases to validate and check
Referential integrity
• Designing BO Reports, including Report Design, Formats, Database
Connectivity and Web / Application Servers.
• Creating Web Intelligence Reports(Full client) with BOXI
• Test and replicate bugs in Business Objects.
• Testing Hot Fix and Service Packs for stability on Business Objects
Products.
•Work closely with the development team during the development phase of the
project to ensure proper Standards and processes are followed.
•Implemented various loads like Daily Loads, Weekly Loads, and Quarterly
Loads using Incremental Loading Strategy
Desirable Technical / Functional Skills
•Assume ownership of identified data issues and risks and provide
documented solutions to any sourcing / data mapping / data quality issues
and risks
•Define and understand source to target mapping and documenting Business
Rules / Use Cases to provide the highest quality data to drive an
innovative Compliance customer experience
• Designing BO Reports, including Report Design, Formats, Database
Connectivity and Web / Application Servers.
• Creating Web Intelligence Reports(Full client) with BOXI
• Test and replicate bugs in Business Objects.
• Testing Hot Fix and Service Packs for stability on Business Objects
Products.
• Document and update the issue resolution knowledge-base on timely basis
• Ensure comprehensive user training and timely communication to GE
whenever required during the support process.
• Support metadata management within the data governance framework enabling
the business to create and use a business glossary for an end-to-end
lineage of data
• Proactively identify and eliminate problems and bugs in existing
applications, with adequate approvals from customer
Desirable Technical / Functional Skills
Total experience in required skill (years) 3-4 Years expereince in
Informatica with BO knowledge
Total experience in required skill (years)
• Minimum of 3+year work experience preferred
Work Location
Eden Prairie
Duration
12 Montsh
*Thanks and Regards*
*Ashutosh Kumar Singh*
*Technical Recruiter*
*IDC Technologies Inc. (**ISO 9001-2008 Certified**)*
*Address:*
* 1851 McCarthy Boulevard, Suite 116, Milpitas, CA, USA, 95035Mail: *
*ashutosh.si...@idctechnologies.com* <ashutosh.si...@idctechnologies.com>*
| Web: **www.idctechnologies.com* <http://www.idctechnologies.com/>
* Tel: **408-457-9399 Ext. 2087 **| IM: **ashutosh24101988 (Gtalk)** |**
YIM: sashutosh00*
*"Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail
cannot be considered spam as long as we include a way to be removed from
our mailing list. Simply send us an e-mail with “REMOVE” in the subject and
we will gladly REMOVE you from our mailing list."*
--
You received this message because you are subscribed to the Google Groups
"as400placements1" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to hrccpl+unsubscr...@googlegroups.com.
To post to this group, send an email to hrccpl@googlegroups.com.
Visit this group at http://groups.google.com/group/hrccpl.
For more options, visit https://groups.google.com/d/optout.
