Job Description :
Teradata Developer with Informatica
Job Location:- Richmond, VA
Duration; Long Term


Professional Experience
- Requires 9+ years of Teradata with Informatica and SSRS Experience
- Expert in creating and analyzing complex stored procedures.
- Knowledge of database administration techniques and database administration tools.
- Experience in design and development of new and existing multi tier online transactional systems.
- Experience in performance tuning and query optimization
- Experience in Healthcare Business, Agile delivery model and Scrum methodologies
- Knowledge of Data Warehouse concept, ETL concepts and tools preferred
- Demonstrated results and competence developing ETL process using Informatica Power Center and Power Exchange 9.6 and above
- Experience in Informatica Velocity proven methodology and ETL Industry standards
- Good understanding of Reporting and Data Warehousing concepts
- Experience in design and development of dashboards and reports, including the development of detailed design specifications using SSRS.
- Design, develop, revise and maintain a wide variety of custom SSRS reports to support business e.g., dashboards, scorecards, custom extracts .
- Support the business for report modification requirements and on demand requests in timely fashion

Mandatory Skills
- INFORMATICA 9.6 and above
- SSRS 2012 and above
- Oracle MS SQL server 2014 and above
- JIRA and Confluence
- Bit Bucket
- Source Tree
- Transformations like Normalizer aggregator Java Transformation
- Putty WINSCP
- Shell scripting and commands
- Excel experience with VLOOKUP and other functions
- MongoDB

Additional skills
- Work closely with DBAs to support and deliver application releases
- Excellent analytical and problem solving skills
- Experience in the health care insurance industries desired
- Excellent written, verbal and interpersonal communication
- SharePoint
- MS Visio
- SQL Sentry
- PL SQL
- Red Gate tools
- SOAP Rest experience

Responsibilities
- Familiar with Logical Data Model and Physical Database design.
- Strong skills in Data Analysis, Data Profiling and Data Mapping for ETL processes.
- Performed analysis of Business and system requirements including Impact analysis of existing systems and create design specifications with the consultation of Business users and technical architects.
- Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
- Experience in database programming in TSQL
- Provides support during the system implementation.
- Partner with the architects to plan and develop solutions.
- May work with business operations to capture metadata to build out data models.
- Work with project teams to plan and execute the quality control process.
- Details all aspects of functional designs, including record layouts, pseudo code, detailed data mapping, etc
- Strong experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor and Repository Manager
- Develop ETL data work flows and code for new data integrations and maintain enhance existing workflow and code.
- Experience in using complex transformations
- Experience in error exception handling using Informatica mapping
- Proficient in performance tuning, usage of partitions, etc.,
- Preferable experience using Informatica IDQ
- Report development experience must include sub reports, writing complex formulas and conditional formatting
- Designs, develops and maintain various business intelligence applications reports, dashboards, scorecards
- Expertized creating parameterized reports, drilldown reports and scheduled reports.

Educational Qualification
- BA BS degree in Computer Science or Information Systems or equivalent combination of education and experience which would provide an equivalent background is required