Company Description
Full time with TCS (Tata Consultancy Services)
www.tcs.com
Job Description
Hi
Hope you are doing great.
Just wanted to touch base with you regarding a Job Opening of an ETL/Informatica Developer based out in NJ or Charlotte or NY for a full time position. Kindly share your updated resume along with your contact details, current location and work authorization (if interested) so that we can process your candidature and represent your candidacy for this role. Should you be not interested in this role, kindly send me a reference of someone who you think can be a potential candidate for this role.
Kindly find the Job Description below for your reference.
Title: ETL/Informatica Developer
Location: NJ or Charlotte or NY
Duration: Full Time Position
Employee Status: Permanent
Interview Process: Phone and Skype Hire
Shift: Day Job
Start Date: ASAP
Job Overview:
Required Experience 7+ years
• 7+ years of hands on experience with /designing/development of informatica applications.
• 5+ years of development experience in delivering ETL/database/programming solution
• Good hands on experience in below informatica concepts
o Performance tuning
o Data modeling and data ware housing concepts
o Reusable transformations
o Partition techniques
• Strong database knowledge Oracle PL/SQL, tuning
• Good knowledge on UNIX scripting
• Able to write complex relational Oracle/SQL server queries to help with data validation
• Expert in writing Oracle procedures, functions, packages and debugging the code.
• ETL knowledge such as Informatica
• Good at troubleshooting the problems
• Understand data/report requirements
• Communicating with business users and other development team
• To be able to meet the deliverables in a tightly timeframe with cost effective Testing and release cycle
• Excellent interpersonal and communication skills.
• Interface and coordinate with other teams whenever required
• Implement enhancements and customizations.
• Provide technical support for issues including hands-on troubleshooting.
Informatica
• Mappings
• Workflows
• Sessions
• Reusable components
• Parameters and Variable
• Performance tuning
o File Handling
o Informatica implementation techniques related to Oracle database
• SCD1 and SCD2 logic implementation
• Oracle
• SQL
• Tables
• Views
• Materialized Views
• Index
• Partitioning
• Procedures
• Functions
• Packages
• PL/SQL scripts
• Performance Tuning
Unix
• Basic Shell commands
• Writing shell scripts
Scheduling
• Autosys
DW concepts
• Data warehouse and Data Mart
• Facts
• Dimensions and Dimension types
• Star and Snowflake schemas
Additional Preferred skills
• Working experience in the tools like TOAD, SVN, Tectia Client for day-to-day activities is recommended.
• Knowledge in SQL server would be a plus.
Qualifications
B.Tech\ Graduate
Additional Information
If available please contact me for more details at 856-842-1988 ext-112
Location: Jersey City, NJ
Posted: Sept. 15, 2024, 6:24 a.m.
Apply Now Company Website